topic Re: How to replace If condition with Set analysis in QlikView

How to replace If condition with Set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can some one guide me how to replace IF condition with Set analysis.

Note : This if condition i am using in Dimension level. As data is very sensitive, I'm not able to upload any QVW application or direct data. This condition in below is example. If you guys help with the below, i can compare with my original data set & replace as per requirement.

Condition:

If(Segment = 'Traffic',

If(Month='January','Jan',

If(Month='February', 'Feb',

If(Month = 'March', 'Mar' ))))

Thanks in advance...

Thanks,

Venkata Sreekanth

Re: How to replace If condition with Set analysis

olivierrobin — Wed, 04 Apr 2018 09:42:30 GMT

hello

i dont't understand what you want to do

set analysis is used to limit the data you are viewing

the if statemnts you show are used to modify the values stored or displayed

so, could you explain what yo want to do

Re: How to replace If condition with Set analysis

Anonymous — Wed, 04 Apr 2018 09:51:03 GMT

Hi Robin,

In my situation, Using If condition i'm deriving the Calculated Dimension.

When ever i made different selection in dashboard, the data which are related to If condition is showing remaining is not displaying.

I want to avoid that... Using set analysis is it possible to represent the calculated dimension ?

Thanks,

Venkata Sreekanth

Re: How to replace If condition with Set analysis

olivierrobin — Wed, 04 Apr 2018 09:58:27 GMT

set analysis are used to create sets of data. they don't interfere with its representation

couls you be more explicit on your need ? I have some difficulties to understand it

Re: How to replace If condition with Set analysis

sasiparupudi1 — Wed, 04 Apr 2018 11:51:08 GMT

May be change your if to

If(Segment = 'Traffic' AND MATCH(Month,'January','Jan','February', 'Feb','March', 'Mar' ))

I think you may not be having a master calender implemented in your data model.. It would be easy to filter your data using expressions and proper dates