Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis within IF statement also using Alternative States

=IF(aggr(minstring({[End]< KPIType = {'Status'} >} KPIStatus),OrgID)='Engaged','1.StatusSame','3.StatusDown')

Hi

Hopefully a simple query, i'm trying to figure out where how I add set analysis into the above If statement to ignore certain fields if selected. - can any one give me any pointers please?

thanks in advance

H

1 Solution

Accepted Solutions
sunny_talwar

Try this

Count(DISTINCT {<Promotion>} OrgId)

View solution in original post

6 Replies
sunny_talwar

This seems like a calculated dimension, do you have to ignore selections in dimensions or do you want to ignore them in your expression so that you chart doesn't change based on selections

Not applicable
Author

Hi Sunny,

Yes it is actually part of a larger nested If statement that creates a calculated dimension.

I would like the chart to ignore certain selections only.

So, for example, I would like the chart to change if Country = England were selected but not if anything from Promotion  were selected.

Kind regards

H

sunny_talwar

What is your expression/s?

Not applicable
Author

count(distinct OrgId)

sunny_talwar

Try this

Count(DISTINCT {<Promotion>} OrgId)

Not applicable
Author

Perfect Sunny, thank you!