Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Can you create a Set Analysis with two Identifiers

Is it possible to have a set analysis that has a different identifier based on what is being selected.  For example, take the below grid:

2016-05-25 13_21_08-Sales Performance Dashboard - Morning Report YTD _ Sheets - Qlik Sense.png

The column [2015-Total] is the same data field as [Last Year] except if for the entire year.  This was accomplished with using the identifier 1 instead of $.  So, it looks like Smiley Frustratedum({1<Year={'$(=vLastYear)'}>}[SALES]).  This causes the filters or selections to be ignored.  All of them.  This works great for ignoring the select date range and shows me the total for 2015, however I also need the other selection to function, which the do not..  The request is really not to ignore all the selection, but to ignore the Year or Month selections and apply the rest.  Is it possible to have the "1" to exclude for two selections and at the same time have the "$" for the other fields like  [sales directors]. 

something like Sum({1<Year={'$(=vLastYear)'}>},{$<Sales Director=>}[SALES])

1 Solution

Accepted Solutions
MVP
MVP

Re: Can you create a Set Analysis with two Identifiers

Or try this to just ignore Date related fields

Sum({$<Year={'$(=vLastYear)'}, Month, MonthYear, Date, Quarter, QuarterYear>}[SALES])

4 Replies
MVP
MVP

Re: Can you create a Set Analysis with two Identifiers

Try like this:

Sum({1<Year={'$(=vLastYear)'}, [Sales Director] = $::[Sales Director]>}[SALES])

MVP
MVP

Re: Can you create a Set Analysis with two Identifiers

Or try this to just ignore Date related fields

Sum({$<Year={'$(=vLastYear)'}, Month, MonthYear, Date, Quarter, QuarterYear>}[SALES])

Not applicable

Re: Can you create a Set Analysis with two Identifiers

That did the trick.  I just need to make those changes to any field with the "1" identifier and include all of the filters.  That's the quick solution!

Not applicable

Re: Can you create a Set Analysis with two Identifiers

Sunny, While both of your suggestions worked perfectly, this option is the one I implemented.   Thanks for the excellent suggestions.