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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggrgation

I want to aggregate on field without to attention to some dimention?

for example i want to sum(x1) without attention some filter affect it.

for example sum(x1, exception field1)?

field 1 is filter like mounth

Labels (1)
1 Reply
johnw
Champion III
Champion III

If you have version 8.5 or above, you can do it with set analysis:

sum({<field1=>}x1)

You can mimic it in earlier versions, but there's a lot more to it.