Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm working on a line chart and i notice that in case i add set analysis to the dimension i cannot hide NULL values.
for example:
I have a dimension Date that i added set analysis to it in order to present values only from this year:
=if(year(Date)=2019 and Date<=today(),Date)
but when i do that the table results with one row of NULL values
and in the line chart dimension there is not checkbox to hide the NULL values.
this later effect the Y axis ranges,
when set to automatic it take into account the value of the NULL row.
Q: how can i hide the null row when using set analysis in the dimension?
I think i found a work around..
by creating a table and un-checking the "Include null values"
and after convert it to line chart..
it works in a simple case.. i hope it will work in other places i need it.
but if some one do know how to bring back the check box in the line chart i will be more then happy!
Have you tried unchecking 'Include null values' under your dimension?
That's what i'm saying that the checkbox is not there 😞
Check version of Qlik Sense are you using and which object?
I'm usign the lates version.
and the line chart is not an extension, it is the one provided with the product
maybe i'm missing something?
I have the same version like yours, but I see that option under my dimension... I am not sure why you are not seeing it
😭i can't find anything that will explain this..
I think i found a work around..
by creating a table and un-checking the "Include null values"
and after convert it to line chart..
it works in a simple case.. i hope it will work in other places i need it.
but if some one do know how to bring back the check box in the line chart i will be more then happy!