topic Pivot Table filtering on expression in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-filtering-on-expression/m-p/1418718#M428295 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with City/State/Month as Dimensions and Popualtion as a measure, created a Change % measure expression by subtracting Feb-Jan months.</P><P></P><P>Now i want to show only data in pivot when the Change % is greator than 0.0400. Is there a way we can create a simple list box or a valuebox where we can give a specific number to filter?</P><P></P><P>Please let me know, thanks.</P><P></P><P><IMG alt="US_Cities_Population.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177786_US_Cities_Population.jpg" style="height: auto;" /></P></BODY></HTML> Tue, 26 Sep 2017 18:43:19 GMT 2017-09-26T18:43:19Z Pivot Table filtering on expression https://community.qlik.com/t5/QlikView/Pivot-Table-filtering-on-expression/m-p/1418718#M428295 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with City/State/Month as Dimensions and Popualtion as a measure, created a Change % measure expression by subtracting Feb-Jan months.</P><P></P><P>Now i want to show only data in pivot when the Change % is greator than 0.0400. Is there a way we can create a simple list box or a valuebox where we can give a specific number to filter?</P><P></P><P>Please let me know, thanks.</P><P></P><P><IMG alt="US_Cities_Population.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177786_US_Cities_Population.jpg" style="height: auto;" /></P></BODY></HTML> Tue, 26 Sep 2017 18:43:19 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-filtering-on-expression/m-p/1418718#M428295 2017-09-26T18:43:19Z