PFA of qvf as well as the excel.
In the qvf, I have grouped according to QoQ on customer group selection. But I want grouping should be automatically done on Leaders as well as at org level(no selection of filter), YoY Trend(only on Fiscal Year).
Like as of now,
for Q4 , <0%, sum(Profit) is -0.72 and sum(Cost) is 47.78 which is correct.
And I want
for no quarter selection, sum(Profit) is 0 and sum(Cost) is 0
for L1 Leader and no quarter selection , sum(Profit) is -8.6 and sum(Cost) is 1.76
for L1 Leader and Q4 , sum(Profit) is -0.2 and sum(Cost) is 45.56
You can check from attached excel....
Here lets say if you're making a straight table.
Make a calculated dimension using the radio buttons input
For Measure try
Here the values would be easily filterable by Leaders, Quarter, etc...
Find my App attached below.
I'm using cyclic group in Qlik sense, you can have full detailed implementation at https://www.quickintelligence.co.uk/qlik-sense-cycle-group/ from stevedark
Then, grouping are calculated in the list using aggr(). this ensure your list will be updated with any other selections in the app
I've renamed Customer Group to Customer group in the data island. The field name and the value in the dimension have to be the same.
demo2.qvf 208.0 K