If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
Set Analysis isn't going to permit nested conditions. It would be used to filter the recordset to fields that had certain values.