topic Re: Qlik Sense chart expression selection in App Development

Qlik Sense chart expression selection

Architect — Mon, 20 Dec 2021 21:02:46 GMT

HI,

I have added these two expressions in my Qlik Sense app.

Expression1>

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

I am using this expression1 for the column = 'Action Item'

Expression2>

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

I am using this expression2 for the column = 'Action'

Below are the columns that I obtain following the expressions-

My Target->

I need to remove all the rows with 'G5' in my final app. and I will have 'Action Item' column with 'G1','G2', and 'G3'

only.

The issue I encountered is, removing 'G5' in the expression will fill up the column with '-' values, and I am not able to remove them in the chart.

Re: Qlik Sense chart expression selection

GaryGiles — Fri, 05 Mar 2021 12:14:00 GMT

Have you un-checked the "Include null values" box for the Action dimension in the chart properties panel?

Re: Qlik Sense chart expression selection

Architect — Fri, 05 Mar 2021 12:34:41 GMT

@GaryGilesyes I have unchecked the box

Re: Qlik Sense chart expression selection

Architect — Fri, 05 Mar 2021 12:53:02 GMT

Now i have also tried the issue to resolve using below 'LEN' expression, but having same output with '-'

as values.

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

Re: Qlik Sense chart expression selection

NitinK7 — Fri, 05 Mar 2021 13:01:30 GMT

If there not a sensitive data then could you please attach here your qvf that will be helpful to check

Re: Qlik Sense chart expression selection

Architect — Fri, 05 Mar 2021 13:47:19 GMT

HI @NitinK7 sharing the file is very difficult.

Re: Qlik Sense chart expression selection

NitinK7 — Fri, 05 Mar 2021 13:57:26 GMT

Ok, I understand

at least please provide your data file with dummy data

and how you calculate v_Rec_GM and vLowvcomp this 2 variables

Re: Qlik Sense chart expression selection

jwjackso — Fri, 05 Mar 2021 15:40:09 GMT

Using this data:

SET vLowvcomp=200;
Data:
Load * Inline [
"v_Rec_GM","Rec. Sales Price"
1,300
-1,100
-1,200
1,100
];

I unchecked "Include zero values" for the measure.

Re: Qlik Sense chart expression selection

Architect — Mon, 08 Mar 2021 10:23:14 GMT

@jwjackso

I have tried following your process,

still, I see those 'zero' values in the chart.

here the 'Action Item' column is dimension.

Re: Qlik Sense chart expression selection

jwjackso — Mon, 08 Mar 2021 16:00:41 GMT

In your case, you have multiple measures. The "REC Sales Price" percentage is non-zero, so the row is not suppressed. In my example, I changed the "Action Item" column from a measure to a dimension, used the Null() function and suppressed nulls on that column.

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