I have two columns: Customer Group and Customer Name
And I have one radio button:
I want to categorize all customer group as well as customer name on the basis of sum(Profit) depending upon the selection of customer selection filter as:
sum(Profit)<0 -> "<0%"
sum(Profit)>=0 and sum(Profit)<10 -> "0-10%"
sum(Profit)>=10 and sum(Profit)<20 -> "10-20%"
sum(Profit)>=20 -> ">=20%"
Also I have one leaders filter , I want when someone selects any leader then grouping should be done corresponding to leaders as well in addition to customer group/customer name.
Hi Divyanshi ,
Can you able to share any file , i didnt understood properly .
If ypu can share anysample , its easy to work on please.
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.
But you are using
while I am calculating sum(Profit) on sum(Profit) categorization.