Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to pass a set analysis function as value to another set analysis?

Please help me to solve the below issue.

First Set analysis function.

Sum({<[Budget_Year='{2013'},Budget_Quarter={'Q2'}]>}Budget)

I want to pass this set analysis function to another set analysis function as value.

like

Sum({<[Financial_Year={'2013'},Budget_Quarter={'Q2'}]>}Sum({<[Budget_Year='{2013'},Budget_Quarter={'Q2'}]>}Budget)) +

Is this Possible to give the another set analysis  function as value in Set analysis.

or is it  possible to give variable as value in set analysis as below?

Sum({<[Budget_Year='{2013'},Budget_Quarter={'Q2'}]>}($vBudget)).

Please let me know how to solve this issue.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

If you want to nest aggregations, i.e. calculated the sum of another sum, then you need to use the aggr function and specify over which dimensions the inner sum should be aggregated. I don't understand what you're actually trying to do. Can you prepare an example document with some data and the results you expect?


talk is cheap, supply exceeds demand