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

How to write Nested If in Set Analysis?

Hi,

I have a query like

=IF(MajorSiteRegion in ('3.P.L','Corus','Fremont','India','Livermore','Metryx','San Jose','Silfex','Tualatin','Villach'),MajorSiteRegion)

In Qlikview it wont allow IN function. How to write the same in Set Analysis or any other alternate way..

Sub2u444    

1 Solution

Accepted Solutions

Re: How to write Nested If in Set Analysis?

Not sure where you are doing this. Is there any aggregation? If not then may using Match or WildMatch function:

If(Match(MajorSiteRegion, '3.P.L', 'Corus', 'Fremont', 'India', 'Livermore', 'Metryx', 'San Jose', 'Silfex', 'Tualatin', 'Villach'), MajorSiteRegion)

3 Replies

Re: How to write Nested If in Set Analysis?

Not sure where you are doing this. Is there any aggregation? If not then may using Match or WildMatch function:

If(Match(MajorSiteRegion, '3.P.L', 'Corus', 'Fremont', 'India', 'Livermore', 'Metryx', 'San Jose', 'Silfex', 'Tualatin', 'Villach'), MajorSiteRegion)

MVP & Luminary
MVP & Luminary

Re: How to write Nested If in Set Analysis?

And if you're talking about set analysis then you can use something like:

count({<MajorSiteRegion={'3.P.L','Corus','Fremont','India','Livermore','Metryx','San Jose','Silfex','Tualatin','Villach'}>} distinct MajorSiteRegion)

That means count the distinct values of MajorSiteRegion that match the values in the list. This useless example should return 10.


talk is cheap, supply exceeds demand
Not applicable

Re: How to write Nested If in Set Analysis?

Thanks for the reply.

I am using it as Dimension, so i used the above one.It works fine.

Thanks for the reply.

Community Browser