QlikSense - Filter a straight table based on user selected variance.

[rajasekhar6067]

I have a straight table where im displaying market value of my products along with variance for different dates as shown in the attached. The user doesn't want to display all records, instead he need a filter pane in which he can select the Tolerance and based on that the table should display the products having variance greater than or equal to the user selected variance.

Can you please help me find a way to get this in QlikSense.

Many Thanks.

[oknotsen]

Please don't post Qlik Sense questions in a QlikView forum.

Topic moved.

[rajasekhar6067 · Accepted solution]

we achieved this by storing the variance value into a variable and modified our measures to display the value if the variance is greater than the selected variance (variable)

SET vVarValue = '=Min([MarketValueTolerance])';

SET vVariance='FABS((FABS(SUM($(vMVTo)) - SUM($(vMVFrom)))/SUM($(vMVFrom)))*100)';

SET vMarketValueTo='if($(vVariance)>$(vVarValue),SUM($(vMVTo)), null())';