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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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
Partner - Champion II
Partner - Champion II

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
Partner - Champion II
Partner - Champion II

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