topic Re: Line chart set ranges to disregard null value in dimension with condition in App Development

Line chart set ranges to disregard null value in dimension with condition

gal_polak — Sat, 16 Nov 2024 05:00:33 GMT

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?

sunny_talwar — Mon, 12 Aug 2019 13:26:46 GMT

Have you tried unchecking 'Include null values' under your dimension?

gal_polak — Mon, 12 Aug 2019 13:31:13 GMT

That's what i'm saying that the checkbox is not there 😞

sunny_talwar — Mon, 12 Aug 2019 13:40:24 GMT

Check version of Qlik Sense are you using and which object?

gal_polak — Mon, 12 Aug 2019 13:52:32 GMT

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?

sunny_talwar — Mon, 12 Aug 2019 13:56:34 GMT

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

gal_polak — Mon, 12 Aug 2019 14:14:56 GMT

😭i can't find anything that will explain this..

gal_polak — Mon, 12 Aug 2019 14:19:57 GMT

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!