Discussion Board for collaboration regarding Qlik DataMarket.
I need to calculate total revenue corresponding to specific group of customer ?
Go to Solution.
You may calculate like below:
Video Link : 4123
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())