Qlik Community

Qlik Sense Cloud Discussions

emmamcginn
New Contributor

How to create a non-aggregated measure

Hi - Can someone please explain how we can create a measure that does not have any aggregation?

Thanks

2 Replies
MVP
MVP

Re: How to create a non-aggregated measure

Use Aggregation Functions!

Maybe you are looking for the Only() function?

Employee
Employee

Re: How to create a non-aggregated measure

Hi Emma,

After speaking with different members of our tech team about your question, I was able to find some info about how to remove aggregations from measures in Qlik Cloud. Essentially, you will remove the description fields in the expressions of the measure so it will read as (). For instance, I removed the (customer) text from the Sum(customer) measure so it just reads as Sum(). This should allow you to use non-aggregated measures.

Measures3.pngMeasures4.pngMeasures5.pngMeasures6.png

Community Browser