Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Zaidan_as
Creator
Creator

Not Showing Null Dimension and Measure

Hello guys, 
Sorry if my english is bad,
Im new in QlikSense environment and I have a question.


So, I have data like this

Screenshot_3.png

So if you look to my data, there are many blank rows. 
Then I want to show Dimension xFinalResult with the measure is Count([xEPLotNo]) without the Null value or Dimension. 


So this is the result of my chart,

chartAC.png

 What I want is this chart don't show the Null Value or Dimension. 
I already unchecked this 

Screenshot_5.png

But the result is just the same like the chart figure above. 


 

Labels (3)
1 Solution

Accepted Solutions
Zaidan_as
Creator
Creator
Author

Okay, i already get the solution.

First, my raw data that contain blank rows data changed to Null like this

Screenshot_6.png

Then I use this in my Field Measure

Count({<xFinalResult-={'NULL'}>}xEPLotNo)

so the result is like this

Screenshot_7.png

View solution in original post

4 Replies
Chanty4u
MVP
MVP

sorry i read wrongly.

try something below

Sum({$<PloNo*={"*"}>} Values)

or

sum({<Plotno-={''}>}values)

Zaidan_as
Creator
Creator
Author

Sorry, but as i stated before, i'm new in QlikSense, 

First, you mention this  

NULLASVALUE Value;
SET NullValue = 'NULL';
LOAD
ID,
Value
FROM
(ooxml, embedded labels, table is Sheet1

I don't know how this work and where I should put it.

Then for this,

= Count({< Value = {'NULL'} >} ID )    

I think this is used for count the NULL, but as I said in the question, I don't want to show the Null Value or Dimension

Zaidan_as
Creator
Creator
Author

Ok, i think i should add some information first,

I'm using xFinalResult for Dimension, and for the measures I used Count(xEPLotNo)

When I insert and modify your answer to my Field measures like this

Count({$<xFinalResult*={"*"}>} xEPLotNo)

or

Count({<xFinalResult-={''}>}xEPLotNo)

I still get the same answer and the Null Value still showed up. 

 

 

Zaidan_as
Creator
Creator
Author

Okay, i already get the solution.

First, my raw data that contain blank rows data changed to Null like this

Screenshot_6.png

Then I use this in my Field Measure

Count({<xFinalResult-={'NULL'}>}xEPLotNo)

so the result is like this

Screenshot_7.png