topic In condition in QlikView

In condition

Fri, 24 Dec 2010 11:00:56 GMT

Hi,

How to write the condition in the Expression in Qlikview

Region in ('LA','NJ','AK')

I am getting error if i am using the in condition in listbox.

In condition

sunil2288 — Fri, 24 Dec 2010 11:06:14 GMT

HI XXX,

You can use set analysis to write this expression like

{$<Region={'LA','NJ','AK'}>}

Regards

Sunil

In condition

Fri, 24 Dec 2010 11:27:25 GMT

Hi Sunil,

It is not working. Sorry for not mentioning the complete scenario.Actually i am trying like this. List box should show the city of the mention regions

If ({$<Region={'LA','NJ','AK'}>},City)

In condition

tresB — Fri, 24 Dec 2010 11:43:00 GMT

Hi,

In that case you can try : If(Region='LA' OR Region='NJ' OR Region='AK', City)

Regards, tresesco

In condition

sunil2288 — Fri, 24 Dec 2010 11:47:50 GMT

HI XXX,

I don't think you can write an expression as dimension.

If you want to do like this you can change these thing in the Load script editor..

((Region='LA' or 'JN' or 'AK'),cITY) AS Sp_REGION

Regards

Sunil

In condition

sparur — Fri, 24 Dec 2010 11:51:07 GMT

Hello, XXX

You can to use a match() function, like as:

IF(Match(Region, 'LA', 'NJ', 'AK') > 0, City)

In condition

Fri, 24 Dec 2010 12:34:51 GMT

Thanks Sunil,tresco, Sparur for the solution . It is working as expected.