Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to display a KPI (like) object with no aggregate function? I summed the cumulative value of my data in the load editor, and now I need to display this value on a month by month basis, the problem is that the KPI object only works with measures which require an aggregate function (sum, max, min, etc) and summing an already summed value will not work for me. Is there a workaround solution for this?
Thank you!
It does not work with only an aggregation function.
At first, Qlik will 'force' you to create an agg function, but you can eliminate it:
see:
It's not working for me
can you share your app please?
Same behavior for us also. When we display any Measure in KPI, logically we need to define what kind of agg we would like to see in KPI.
Eg: Measure is Net Impact. We need to define we need to see sum of net impact, min or max or count of Net Impact in KPI. This is logical too