How to avoid blank column in dimension

[ramrongala]

Hi Experts,

I have created below table in qliksense, null values handled by using 'NULLASVALUE' but still showing blank column 

But i removed Actual expression, the blank column gone but user need both and avoid blank column .

Please help me why this blank coming any data related issue or fronted or expression issue .

Departments	# Targets	Actual
Sales	8	1086
Finance	25	1447
INITIATORS	8	1024
Social	2	726
-	4	529
	0	2207

[GreatGreekYogurt]

Hard to understand the exact issue here. Please share a sample of the dataset.

[jobsonkjoseph]

Hi

if you do not want to display the fields with blanks or nulls you can uncheck the null option in table properties.

[ArnadoSandoval]

Hi @ramrongala 

I suggest you to read the PDF document attached to this document: NULL handling in QlikView and perhaps this help article should be helpful NullAsValue 

Hope this helps,