Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: Display a KPI object with no aggregate function?

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

Re: Display a KPI object with no aggregate function?

It's not working for me

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

OmarBenSalem
Not applicable

Re: Display a KPI object with no aggregate function?

can you share your app please?

Not applicable

Re: Display a KPI object with no aggregate function?

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