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

santoshknc — Sat, 16 Nov 2024 07:04:00 GMT

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.

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

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

santoshknc — Wed, 12 Dec 2018 15:45:11 GMT

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

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

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

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