Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using set identifier with multiple set analysis

Maybe its just the syntax that's screwing me up.  My issue is i want to do the set analysis say for Year=2016, and Month=Jul, exluding all selections.

Sum({1<[Year]={'2016'}>*<[Month]={'Jul'}>}Sales)

This behaves the same way with or without the 1.  The year and month sets work on their own, and if i combine the 1 with only one field of set analysis it works, but not all at the same time.

Any Ideas?

Thanks

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Sum({1<[Year]={'2016'}, [Month]={'Jul'}>}Sales)

View solution in original post

1 Reply
sunny_talwar

Try this:

Sum({1<[Year]={'2016'}, [Month]={'Jul'}>}Sales)