topic Set Analysis within IF statement also using Alternative States in QlikView

Set Analysis within IF statement also using Alternative States

Wed, 31 May 2017 10:52:26 GMT

=IF(aggr(minstring({[End]< KPIType = {'Status'} >} KPIStatus),OrgID)

='Engaged','1.StatusSame','3.StatusDown')

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

Re: Set Analysis within IF statement also using Alternative States

sunny_talwar — Wed, 31 May 2017 10:54:55 GMT

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

Re: Set Analysis within IF statement also using Alternative States

Wed, 31 May 2017 11:02:20 GMT

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

Re: Set Analysis within IF statement also using Alternative States

sunny_talwar — Wed, 31 May 2017 11:04:39 GMT

What is your expression/s?

Re: Set Analysis within IF statement also using Alternative States

Wed, 31 May 2017 11:37:34 GMT

count(distinct OrgId)

Re: Set Analysis within IF statement also using Alternative States

sunny_talwar — Wed, 31 May 2017 11:38:49 GMT

Try this

Count(DISTINCT {<Promotion>} OrgId)

Re: Set Analysis within IF statement also using Alternative States

Wed, 31 May 2017 11:50:48 GMT

Perfect Sunny, thank you!