This content has been marked as final. Show 7 replies
I have data as below
In Qliksense frontend, I want to show the monthly values as shown in table
But quarterly value for Q1 should be 10000, not the sum of all three(30000)
and for Q2 it should be 20000, and not sum of all three (60000)
When user selects on the quarter filter, instead of sum of all three, only 10000 ( for Q1) and 20000 ( for Q2) should show in the chart.
WHat is the way to achieve this? Can an alternate dimesnion be added in the same chart ? and aggr fucntion be used to add another variable, quarterly target, ?
Please share the fucntion or way to achieve this