Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my Qliksense report I have a calculated measure like below (simplified it)
=if(aggr(sum(QTY), ITEM,FCST_WEEK)>var_Limit,'YES')
Basically if the user selects 'YES' for this expression, report selects the fields for which the aggregated QTY at ITEM and FCST_WEEK level is greater than the value in the variable.
What I want is, when the 'YES' is selected for the above expression value, report needs to select just ITEM and ignore FCST_WEEK i.e. User just wants to filter only the ITEMs that are selected from the expression above. By default it selects both ITEM and FCST_WEEK.
I hope the question is clear.
So is there way to clear the selection on FCST_WEEK and keep only the ITEMs selected?
Thanks,
Manoj
Would something similar to the below work for what you are trying to do?
=if(aggr(sum(QTY), ITEM,FCST_WEEK)>var_Limit,aggr(sum(QTY), ITEM),aggr(sum(QTY), ITEM,FCST_WEEK))
E.g. the IF will check if the item has met the condition and then calculate accordingly.
Thanks. Unfortunately this won't work. The second aggr by ITEM calculated for the subset of ITEMs from the first. Hence it still selects those FCST_WEEK.
Why does FCST_WEEK need to included in the calculation if you don't want a subset based on it?
Are you able to share the file?
The actual expression is a MAPE calculation between a baseline quantity and forecast. The MAPE is calculated at ITEM and FCST_WEEK level.
The user wants to select all ITEMs for which the MAPE is more than var_Limit. So if I don't include FCST_WEEK in my aggr. then the MAPE calculation will go wrong.
For the file, let me create a mock up report with dummy data and share it here.