I need to calculate total revenue corresponding to specific group of customer ?
Qlik Sense Group By Clause - Qlik Sense for Beginners #15
You may calculate like below:
ok. but I want to add aggregate function in if function ?
How can I apply??
Please try below one:
If(ID=1 and Name='ABc',Aggr(Sum(Revenue),CustomerGroup),Null())
Retrieving data ...