Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 ...)