https://community.qlik.com/t5/QlikView/Is-it-possible-to-filter-pivot-table-rows-based-on-a-variable/m-p/1701632#M726357 <P>Try changing the expression to:</P><P>If(sum(Amount)&gt;$(vThreshold),&nbsp;sum(Amount))</P> Wed, 13 May 2020 14:54:42 GMT fosuzuki 2020-05-13T14:54:42Z https://community.qlik.com/t5/QlikView/Is-it-possible-to-filter-pivot-table-rows-based-on-a-variable/m-p/1700517#M726356 <P>I'm hoping someone can take a look at the attached sample file and tell me if it's possible to set up qlikview to filter rows out of the pivot table based on the sum(amount) expression using a variable/slider.</P><P>&nbsp;</P><P>I'd like to set it up so that it only displays rows in the pivot table when the 2019 sum(amount) value is greater than or equal to the value set by the slider.</P><P>Is that possible to do?</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:40:11 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-filter-pivot-table-rows-based-on-a-variable/m-p/1700517#M726356 DJF 2024-11-16T18:40:11Z https://community.qlik.com/t5/QlikView/Is-it-possible-to-filter-pivot-table-rows-based-on-a-variable/m-p/1701632#M726357 <P>Try changing the expression to:</P><P>If(sum(Amount)&gt;$(vThreshold),&nbsp;sum(Amount))</P> Wed, 13 May 2020 14:54:42 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-filter-pivot-table-rows-based-on-a-variable/m-p/1701632#M726357 fosuzuki 2020-05-13T14:54:42Z