Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with Set Analysis

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 ?

3 Replies
rubenmarin

Hi Muntazir, try with

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

or

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

jagan
Luminary Alumni
Luminary Alumni

HI,

Try like this

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


OR


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


OR


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


OR simply give


'ABC' in expression


Hope it helps you.


Regards,

Jagan.

Not applicable
Author

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