Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
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
Ok, Solved this by doing some checks in the expression.
View solution in original post