How to replace If condition with Set analysis

[Anonymous]

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

[olivierrobin]

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

[Anonymous]

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

[olivierrobin]

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

[sasiparupudi1]

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