topic Limit pivot table to specific conditions in QlikView https://community.qlik.com/t5/QlikView/Limit-pivot-table-to-specific-conditions/m-p/974828#M970030 <HTML><HEAD></HEAD><BODY><P>Hey there - I'm loving Qlik. Every day I'm in it using new expressions to make my life easier! Here's a challenge I have.</P><P>The below pivot table contains 6 rows of data where there is a different models on each row.</P><P></P><P>I have another field called BTS which is either Yes or No. The values in the table are just average pricing.</P><P></P><P>My challenge is -- what do I need to do (can you please be specific) in order to get this table so that ONLY models are shown when the No and Yes contain a value?</P><P><IMG alt="2015-09-17 15_37_26-QlikView x64 - [C__Users_james.kennedy_Desktop_GfK Promotion and Causal Retail -.png" class="jive-image image-1" src="/legacyfs/online/99278_2015-09-17 15_37_26-QlikView x64 - [C__Users_james.kennedy_Desktop_GfK Promotion and Causal Retail -.png" style="height: auto;" /></P></BODY></HTML> Thu, 17 Sep 2015 19:45:45 GMT 2015-09-17T19:45:45Z Limit pivot table to specific conditions https://community.qlik.com/t5/QlikView/Limit-pivot-table-to-specific-conditions/m-p/974828#M970030 <HTML><HEAD></HEAD><BODY><P>Hey there - I'm loving Qlik. Every day I'm in it using new expressions to make my life easier! Here's a challenge I have.</P><P>The below pivot table contains 6 rows of data where there is a different models on each row.</P><P></P><P>I have another field called BTS which is either Yes or No. The values in the table are just average pricing.</P><P></P><P>My challenge is -- what do I need to do (can you please be specific) in order to get this table so that ONLY models are shown when the No and Yes contain a value?</P><P><IMG alt="2015-09-17 15_37_26-QlikView x64 - [C__Users_james.kennedy_Desktop_GfK Promotion and Causal Retail -.png" class="jive-image image-1" src="/legacyfs/online/99278_2015-09-17 15_37_26-QlikView x64 - [C__Users_james.kennedy_Desktop_GfK Promotion and Causal Retail -.png" style="height: auto;" /></P></BODY></HTML> Thu, 17 Sep 2015 19:45:45 GMT https://community.qlik.com/t5/QlikView/Limit-pivot-table-to-specific-conditions/m-p/974828#M970030 2015-09-17T19:45:45Z Re: Limit pivot table to specific conditions https://community.qlik.com/t5/QlikView/Limit-pivot-table-to-specific-conditions/m-p/974829#M970031 <HTML><HEAD></HEAD><BODY><P>‌one option is to use set analysis and use the length&nbsp; - lent() function to see if the credulity is greater than 0</P><P></P><P>see thread below for further detailed information</P><P><A href="https://community.qlik.com/thread/108622">Blank or NULL in Set Analysis</A></P></BODY></HTML> Fri, 18 Sep 2015 01:54:29 GMT https://community.qlik.com/t5/QlikView/Limit-pivot-table-to-specific-conditions/m-p/974829#M970031 2015-09-18T01:54:29Z