Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
afroz_shaik
Contributor III
Contributor III

GetCurrentSelection has multiple values Selected, how to calculate sum of sales for respective selected values?

I have a 4 level Drill-down dimension, when i select multiple values, how to calculate sum of sales for that respective selected dimension values.

For example:

My first level is State- I will select one or multiple states - when i select one state i need sales for that sate and if i select multiple states then i need sum of sales for that state. But when i drill down with multiple states selected to next level which is city and select multiple cities then i need to show sum of sales for that Selected cities.

Thanks in Advance.