Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

How to replace If condition with Set analysis

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

4 Replies
Highlighted
Specialist III
Specialist III

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

Highlighted
Specialist
Specialist

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

Highlighted
Specialist III
Specialist III

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

Highlighted
Master III
Master III

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