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

[santoshknc]

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

[santoshknc · Accepted solution]

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