{"id":8703,"date":"2019-05-10T03:27:06","date_gmt":"2019-05-10T01:27:06","guid":{"rendered":"http:\/\/www.sigterritoires.fr\/?p=8703"},"modified":"2023-04-28T14:57:06","modified_gmt":"2023-04-28T12:57:06","slug":"conditional-formatting-of-attribute-tables-with-qgis-2-12","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/conditional-formatting-of-attribute-tables-with-qgis-2-12\/","title":{"rendered":"Conditional formatting of attribute tables with QGis 2.12"},"content":{"rendered":"\n
Following innovations introduced by QGis version\n2.12 : as in Excel tables, now\nyou\ncan\ncontrol\nthe cells setting of the attribute table\nof a layer . \n\nNow you can apply\nconditional rules on the format implementation of\nthe attribute table. To this end , open the\nattribute table of a layer\n. On the right, you will see a new\nbutton for the conditional setting. \n\n\n\n<\/p>\n\n\n\n\n\n\n\n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nClick\non the button to open\nthe formatting panel. \n\n\n\n<\/p>\n\n\n\n You can format\na particular\ncolumn or the entire line by selecting\nField or Complete Line . For the field, you\nmust\nindicate\nwhich\nis\nthe field where you want to apply\na\nformat condition. \n\nTo include a formatting\nrule, click the New Rule button . Then, you will\nget\nthe conditional rule configuration panel: \n\n\n\n<\/p>\n\n\n\n You can enter\na\nname,<\/em><\/strong> but for now, it is used nowhere\n. \n\nThe @value variable\nrepresents the value of the cell. You can\ntype directly a condition, for example\n@value> 3.0<\/em><\/strong> or\nopen\nthe\ncondition assistant by clicking on the button \u03b5<\/strong>\n.\n\n\n\n<\/p>\n\n\n\n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nAs in all\nthe classic expressions in QGis, you can\nrefer to other fields of the table. Once the condition is entered\n, you control the setting in\nform\nassociated\nwith the lower panel : \n\n\n\n<\/p>\n\n\n\n The drop-down menu presents\nsome\npre-established setting options. <\/p>\n\n\n\n You can control\nthe background colors and characters, add an icon\nat\nthe beginning of the cell ( from the QGis characters ), and control the formatting\nand the characters font. \n\nFor a single column you\ncan\nenter\nmany\nimplementation\nformatting rules. In the following example, the wave heights are\nclassified\nin\nthree groups , each with a different formatting.. The column hour<\/em>\nis\nclassified\nto put in evidence day and night .\n\n\n\n\n<\/p>\n\n\n\n Warning: the<\/strong> formatting<\/strong> is<\/strong>\nsaved<\/strong> in<\/strong> the<\/strong> QGis<\/strong>\nproject<\/strong> .<\/strong> If<\/strong> you<\/strong>\nopen<\/strong> the table<\/strong> in<\/strong> a<\/strong>nother<\/strong> project,\nit is not taken into account. <\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" Following innovations introduced by QGis version 2.12 : as in Excel tables, now you can control the cells setting of the attribute table of a layer . Now you can apply conditional rules on the format…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1260],"tags":[],"class_list":["post-8703","post","type-post","status-publish","format-standard","hentry","category-non-classe-en"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n