Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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