Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Architect
Creator
Creator

How to use Set Expression in front end instead of the 'if' statement in script.

 
 

Hi,

I below is the 'IF' statement that I want to replace with 'Set expression'

Please note this expression is used inside the column expression of a Chart.

If(
$(v_Rec_GM)>0 and ([Rec. Sales Price])>= $(vLowcomp), 'G2',
If( $(v_Rec_GM)<=0 and ([Rec. Sales Price])>= $(vLowcomp), 'G1',null)
)

Here I want to replace this IF statement with a Set expression. Not to do in the script, only to change in column expression.

@marcus_sommer 

@jwjackso 

@NitinK7 

Labels (1)
1 Reply
Dalton_Ruer
Employee
Employee

Set Analysis isn't going to permit nested conditions. It would be used to filter the recordset to fields that had certain values.