topic Conditional Dimension Exclusion in QlikView https://community.qlik.com/t5/QlikView/Conditional-Dimension-Exclusion/m-p/463817#M486544 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: verdana, geneva;">Good time of the day to you.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">In my application, I have a Comp Status field that has values 'Comp', and 'Non-Comp'. Underlying data has two corresponding columns. One - "Comp Status", another - "Next Year Comp Status" for last year calculations. Underlying data looks something like this:</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;"><IMG __jive_id="33793" class="jive-image" alt="Data-Sample.png" src="https://community.qlik.com/legacyfs/online/33793_Data-Sample.png" /></SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">In my Straight Table I have two columns for this, and last year. When I select "Comp Status" to be 'Comp' I have to aggregate based on Comp Status for this year (which is done automatically), and on Next Year Comp Status for last year calculation, which I do using set expression.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">With this setup Totals are being calculated properly, but when it comes to showing individual locations on rows, location #3 does not appear in the set.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">How can I override default behavior to filter dimension based on its Comp Status and instead have it filter on the expression that would take Next Year Comp Status into the same consideration?</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">Please let me know if my question needs more clarification. Thank you for your attention!<BR /></SPAN></P></BODY></HTML> Fri, 22 Feb 2013 16:09:25 GMT 2013-02-22T16:09:25Z Conditional Dimension Exclusion https://community.qlik.com/t5/QlikView/Conditional-Dimension-Exclusion/m-p/463817#M486544 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: verdana, geneva;">Good time of the day to you.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">In my application, I have a Comp Status field that has values 'Comp', and 'Non-Comp'. Underlying data has two corresponding columns. One - "Comp Status", another - "Next Year Comp Status" for last year calculations. Underlying data looks something like this:</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;"><IMG __jive_id="33793" class="jive-image" alt="Data-Sample.png" src="https://community.qlik.com/legacyfs/online/33793_Data-Sample.png" /></SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">In my Straight Table I have two columns for this, and last year. When I select "Comp Status" to be 'Comp' I have to aggregate based on Comp Status for this year (which is done automatically), and on Next Year Comp Status for last year calculation, which I do using set expression.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">With this setup Totals are being calculated properly, but when it comes to showing individual locations on rows, location #3 does not appear in the set.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">How can I override default behavior to filter dimension based on its Comp Status and instead have it filter on the expression that would take Next Year Comp Status into the same consideration?</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">Please let me know if my question needs more clarification. Thank you for your attention!<BR /></SPAN></P></BODY></HTML> Fri, 22 Feb 2013 16:09:25 GMT https://community.qlik.com/t5/QlikView/Conditional-Dimension-Exclusion/m-p/463817#M486544 2013-02-22T16:09:25Z Re: Conditional Dimension Exclusion https://community.qlik.com/t5/QlikView/Conditional-Dimension-Exclusion/m-p/463818#M486546 <HTML><HEAD></HEAD><BODY><P>"<SPAN style="font-family: verdana, geneva;">With this setup Totals are being calculated properly, but when it comes to showing individual locations on rows, location #3 does not appear in the set."</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">Do you mean that, from the table of data you provided' row no 4 is not shown ?</SPAN></P><P><SPAN style="font-family: verdana, geneva;">A sample application may help.<BR /></SPAN></P><P><SPAN style="font-family: verdana, geneva;">Jonathan<BR /></SPAN></P></BODY></HTML> Mon, 25 Feb 2013 08:05:20 GMT https://community.qlik.com/t5/QlikView/Conditional-Dimension-Exclusion/m-p/463818#M486546 Anonymous 2013-02-25T08:05:20Z