topic Re: Remove Null values from Straight Table Chart with Expressions in QlikView

Remove Null values from Straight Table Chart with Expressions

cliff_clayman — Tue, 21 Jun 2016 20:08:11 GMT

I have a straight table chart with 4 dimensions and 3 expressions. The 3 expressions are just SUMs. I am getting null values in one of my fields that I do not want to see. I checked Suppress When Value Is Null for that Dimension, but the null values still display. How can I remove those null values?

Re: Remove Null values from Straight Table Chart with Expressions

trdandamudi — Tue, 21 Jun 2016 20:20:29 GMT

Can you please share a sample so that we can take a look.

Re: Remove Null values from Straight Table Chart with Expressions

cliff_clayman — Tue, 21 Jun 2016 20:26:49 GMT

Division	Unit	Code	Age	YTD Avg Mo	YTD Avg $	YTD Avg Items
	1	1234	30	1	1000	100
	2	4567	60	2	2000	200
	3	7890	90	3	3000	300
	1	1234	30	1	1500	150
	2	4567	60	2	2500	250
	3	7890	90	3	3500	350
	1	1234	30	1	1250	125
	2	4567	60	2	2250	225
	3	7890	90	3	3250	325
A	1	1234	30	1	1000	100
A	2	4567	60	2	2000	200
A	3	7890	90	3	3000	300
B	1	1234	30	1	1500	150
B	2	4567	60	2	2500	250
B	3	7890	90	3	3500	350
C	1	1234	30	1	1250	125
C	2	4567	60	2	2250	225
C	3	7890	90	3	3250	325

Re: Remove Null values from Straight Table Chart with Expressions

sunny_talwar — Tue, 21 Jun 2016 21:22:04 GMT

For the Division dimension can you try a calculated dimension....

If(Len(Trim(Division)) > 0, Division)

and then use 'Suppress When Value is Null' option on the dimension tab...