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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

I want the Mode value to display on all fields.

I have found the correct Mode value. Now I'm stuck with a problem: the data isn't showing in every field. What should I do?

Paknanarn23_0-1697683825111.png

Paknanarn23_1-1697683851304.png

 

This is my code please help me at

1 Solution

Accepted Solutions
marcus_sommer

Because of the missing outer expression wrapping the aggr() you don't have an expression else a calculated dimension. Therefore try to add a min/max/avg() wrapping it or by adjusting the aggr() behaviour by extending it with: aggr(NODISTINCT ...)

View solution in original post

1 Reply
marcus_sommer

Because of the missing outer expression wrapping the aggr() you don't have an expression else a calculated dimension. Therefore try to add a min/max/avg() wrapping it or by adjusting the aggr() behaviour by extending it with: aggr(NODISTINCT ...)