topic Help with Set Analysis in QlikView

Help with Set Analysis

Wed, 01 Apr 2015 07:21:58 GMT

Hi Community,

I am trying to create a simple table with many dimesnions one of the dimensions is Status and i want only status as ABC to be shown. But when im writing the set analysis in dimension it is giving me invalid dimension and when im doing it in measure it is giving me null values. Can anyone help me on this ?

Re: Help with Set Analysis

rubenmarin — Wed, 01 Apr 2015 07:38:44 GMT

Hi Muntazir, try with

Only({<Status={'ABC'}>} Status)

Aggr(Only({<Status={'ABC'}>} Status), Status)

Re: Help with Set Analysis

jagan — Wed, 01 Apr 2015 07:45:26 GMT

HI,

Try like this

Only({<Status={'ABC'}>} Status)

MaxString({<Status={'ABC'}>} Status)

OR simply give

'ABC' in expression

Hope it helps you.

Regards,

Jagan.

Re: Help with Set Analysis

Wed, 01 Apr 2015 09:01:35 GMT

Hi,

You can accomplish this without set too. Try the following as a calculated dimension:

If( Status= 'ABC', Status)

Please check suppress null.

Regards

Rahul Lakhina