Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display a KPI object with no aggregate function?

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!

4 Replies
OmarBenSalem

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:

Capture.PNG

Not applicable
Author

It's not working for me

Screen Shot 2017-03-28 at 4.06.58 PM.png

OmarBenSalem

can you share your app please?

Not applicable
Author

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