Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rajasekhar6067
New Contributor II

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

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.

Tags (1)
1 Solution

Accepted Solutions
rajasekhar6067
New Contributor II

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

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())';

View solution in original post

2 Replies
oknotsen
Honored Contributor III

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

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

Topic moved.

May you live in interesting times!
rajasekhar6067
New Contributor II

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

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())';

View solution in original post