Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
santoshknc
Partner - Creator
Partner - Creator

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
santoshknc
Partner - Creator
Partner - Creator
Author

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

View solution in original post

1 Reply
santoshknc
Partner - Creator
Partner - Creator
Author

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