Qlik Community

New to Qlik Sense

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramrongala
Contributor II
Contributor II

How to avoid blank column in dimension

 

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# TargetsActual
Sales81086
Finance251447
INITIATORS81024
Social2726
-4529
 02207
3 Replies
GreatGreekYogurt
Contributor III
Contributor III

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

jobsonkjoseph
Creator III
Creator III

Hi

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

ArnadoSandoval
Specialist II
Specialist II

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,

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.