Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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

Tags (2)
1 Solution

Accepted Solutions

Re: Using set identifier with multiple set analysis

Try this:

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

1 Reply

Re: Using set identifier with multiple set analysis

Try this:

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