topic Re: How to write the expression to work according when selected in filter ? in QlikView https://community.qlik.com/t5/QlikView/How-to-write-the-expression-to-work-according-when-selected-in/m-p/1218715#M848114 <HTML><HEAD></HEAD><BODY><P>The Status columns in the charts are not coming directly from Status field, rather they are calculated values (check expression tab). If you want them as in selection, replace the expression for Status column with simple <SPAN style="font-size: 13.3333px;">expression </SPAN><STRONG>=Status </STRONG></P></BODY></HTML> Thu, 16 Mar 2017 09:19:19 GMT tresB 2017-03-16T09:19:19Z How to write the expression to work according when selected in filter ? https://community.qlik.com/t5/QlikView/How-to-write-the-expression-to-work-according-when-selected-in/m-p/1218714#M848113 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>The report is not working according to the filter selection. Sample model attached. there are two reports present in two tab.Screenshot attached.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156471_Capture.PNG" style="height: 364px; width: 620px;" /></P><P></P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/156472_Capture1.PNG" style="height: 410px; width: 620px;" /></P><P></P><P></P><P></P><P>Sample model attached.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression-to-work-according-when-selected-in/m-p/1218714#M848113 suvechha_b 2020-11-25T16:16:04Z Re: How to write the expression to work according when selected in filter ? https://community.qlik.com/t5/QlikView/How-to-write-the-expression-to-work-according-when-selected-in/m-p/1218715#M848114 <HTML><HEAD></HEAD><BODY><P>The Status columns in the charts are not coming directly from Status field, rather they are calculated values (check expression tab). If you want them as in selection, replace the expression for Status column with simple <SPAN style="font-size: 13.3333px;">expression </SPAN><STRONG>=Status </STRONG></P></BODY></HTML> Thu, 16 Mar 2017 09:19:19 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression-to-work-according-when-selected-in/m-p/1218715#M848114 tresB 2017-03-16T09:19:19Z Re: How to write the expression to work according when selected in filter ? https://community.qlik.com/t5/QlikView/How-to-write-the-expression-to-work-according-when-selected-in/m-p/1218716#M848115 <HTML><HEAD></HEAD><BODY><P>Hi Tresesco ,</P><P></P><P>How to handle when Status not selected.</P><P></P><P><IMG alt="Capture2.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156479_Capture2.PNG" style="height: 448px; width: 620px;" /></P><P></P><P></P><P></P><P><IMG alt="Capture3.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/156480_Capture3.PNG" style="height: 305px; width: 620px;" /></P></BODY></HTML> Thu, 16 Mar 2017 09:43:33 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression-to-work-according-when-selected-in/m-p/1218716#M848115 suvechha_b 2017-03-16T09:43:33Z Re: How to write the expression to work according when selected in filter ? https://community.qlik.com/t5/QlikView/How-to-write-the-expression-to-work-according-when-selected-in/m-p/1218717#M848116 <HTML><HEAD></HEAD><BODY><P>When there are multiple possible values, you can choose to see it as null (as you see now) or choose to see all of them separated by delimiter. For multiple values, you can try expression like: <EM>= Concat( Distinct Status, ',' )</EM></P></BODY></HTML> Thu, 16 Mar 2017 09:47:18 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression-to-work-according-when-selected-in/m-p/1218717#M848116 tresB 2017-03-16T09:47:18Z