Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Need help in creating calculated dimension along with conditions in qliksense straight table

Hi Guys,

I need a help in front end in Straight Table in QlikSense. I got 4 dimensions and  7 measures in the table.

Now i need to create new Dimension with the conditions on combination of measures and dimensional values. I will explain properly below, please help me with your ideas.

The below is the look and feel of table display.

Dim_1  |  Dim_2 |  Meas_1 | Meas_2 | Meas_3 | Meas_4 | Meas_5 | Meas_6 | Meas_7 | Dim_3 | Dim_4 

 

Now i need to create 5th Dimension and i need the conditions to be followed to create this dimension.

Conditions are

1. If (Meas_1 and Meas_2 and Meas_3 are NULL, 'Waiting',Dim_4)

2. If (Dim_3 ='Cond1' and Dim_4='Cond2','Waiting',Dim_4)

Now my 5th dimension should be the combination of the above 2 conditions. 

 

Kindly help me out. Thanks in Advcance

 

Thanks,

Santosh

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Ok, Solved this by doing some checks in the expression.

View solution in original post

1 Reply
Highlighted
Partner
Partner

Ok, Solved this by doing some checks in the expression.

View solution in original post