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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
Kim2
Contributor
Contributor

Qliksense

 

 

1 Reply
rubenmarin
MVP
MVP

Hi, why only 1 row has to be one. You can add 2 expressions:

- One with: sum(aggr((sum(................),ORA,MACROSETUSO_DESCRIZIONE_PROGRAM,UTENTE)))

- Another with: sum(aggr((sum(................),ORA,MACROSETUSO_DESCRIZIONE_PROGRAM,UTENTE)))
-above(
rangesum(sum(aggr((sum(...............),ORA,MACROSETUSO_DESCRIZIONE_PROGRAM,UTENTE))))

Those with the 2nd expression higher than 10000 will have '1'. The expressiona re just to see the values returned and you can understand why it sets more than one '1'.