Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
Sorry if my english is bad,
Im new in QlikSense environment and I have a question.
So, I have data like this
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,
What I want is this chart don't show the Null Value or Dimension.
I already unchecked this
But the result is just the same like the chart figure above.
Okay, i already get the solution.
First, my raw data that contain blank rows data changed to Null like this
Then I use this in my Field Measure
Count({<xFinalResult-={'NULL'}>}xEPLotNo)
so the result is like this
sorry i read wrongly.
try something below
Sum({$<PloNo*={"*"}>} Values)
or
sum({<Plotno-={''}>}values)
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
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.
Okay, i already get the solution.
First, my raw data that contain blank rows data changed to Null like this
Then I use this in my Field Measure
Count({<xFinalResult-={'NULL'}>}xEPLotNo)
so the result is like this