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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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