topic Problem with variable as dimension - bar chart in QlikView https://community.qlik.com/t5/QlikView/Problem-with-variable-as-dimension-bar-chart/m-p/1040494#M350237 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>i try to do Trellis Chart showing month for specific Unit but showing only 2 units from 5. </P><P></P><P>List of My Values/Units= [Jednostka Bizensowa]</P><P></P><P>JB01, JB02, JB98, JB97, JB00</P><P></P><P>My Expression is like this:</P><P></P><P>If(left([Jednostka biznesowa],4)='JB01' or l<SPAN style="font-size: 13.3333px;">eft([Jednostka biznesowa],4)='JB02'</SPAN>, left([Jednostka biznesowa],4),null())</P><P></P><P>In this way when i have not had selected any values (and i want to leave this in that way)&nbsp; i have something like below:<IMG alt="Bez&nbsp;tytułu.jpg" class="jive-image image-1" src="/legacyfs/online/113424_Bez&nbsp;tytułu.jpg" style="height: 345px; width: 620px;" /></P><P></P><P>This strange "-" is my null (). Is is possible to write expression to not show this null value, only JB01 and JB02?</P><P></P><P>Thnak you in advance for your support,</P><P>Jacek Antek</P></BODY></HTML> Wed, 03 Feb 2016 12:51:50 GMT Anonymous 2016-02-03T12:51:50Z Problem with variable as dimension - bar chart https://community.qlik.com/t5/QlikView/Problem-with-variable-as-dimension-bar-chart/m-p/1040494#M350237 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>i try to do Trellis Chart showing month for specific Unit but showing only 2 units from 5. </P><P></P><P>List of My Values/Units= [Jednostka Bizensowa]</P><P></P><P>JB01, JB02, JB98, JB97, JB00</P><P></P><P>My Expression is like this:</P><P></P><P>If(left([Jednostka biznesowa],4)='JB01' or l<SPAN style="font-size: 13.3333px;">eft([Jednostka biznesowa],4)='JB02'</SPAN>, left([Jednostka biznesowa],4),null())</P><P></P><P>In this way when i have not had selected any values (and i want to leave this in that way)&nbsp; i have something like below:<IMG alt="Bez&nbsp;tytułu.jpg" class="jive-image image-1" src="/legacyfs/online/113424_Bez&nbsp;tytułu.jpg" style="height: 345px; width: 620px;" /></P><P></P><P>This strange "-" is my null (). Is is possible to write expression to not show this null value, only JB01 and JB02?</P><P></P><P>Thnak you in advance for your support,</P><P>Jacek Antek</P></BODY></HTML> Wed, 03 Feb 2016 12:51:50 GMT https://community.qlik.com/t5/QlikView/Problem-with-variable-as-dimension-bar-chart/m-p/1040494#M350237 Anonymous 2016-02-03T12:51:50Z