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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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.