Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aviadbein
New Contributor II

Visualization issue - Line Chart

Hi all,

communityquest.png

Attached screenshot of a line chart of dimension with two values (2 lines - blue and red) and for some reason I get third gray line that does not appear in my database.

i tried to get rid of it but so far without success. any suggests?


Thanks in advance

Tags (1)
1 Solution

Accepted Solutions
plu
Contributor III

Re: Visualization issue - Line Chart

Actually, I just found a workaround.

Switch off continuous mode on the X-axis property in presentation. Go to data section and uncheck the null value option. Then turn continuous mode back on and the line should be gone.

Definitively a visual bug where the option should not be removed.

Regards,

Patrik.

13 Replies
omarbensalem
Esteemed Contributor

Re: Visualization issue - Line Chart

Can you please share your app, to directly take a look at your chart?

satheshreddy
Contributor III

Re: Visualization issue - Line Chart

Hi Aviad,

Please change the color for third Line.

regards

Sathish

plu
Contributor III

Re: Visualization issue - Line Chart

Hi Aviad,

You have null values in your data, time periods with data but no caNickName. Go into the second dimension and uncheck "Include null values"

Null value.PNG

Regards,

Patrik.

aviadbein
New Contributor II

Re: Visualization issue - Line Chart

Hi Sathish,

But there is no data of third line. Actually, it's a ghost line. Maybe it's a result of null values, but if it's the reason why I don't have "Include null values" check box on the dimension?

aviadbein
New Contributor II

Re: Visualization issue - Line Chart

Hi Patrik,

It's exactly what I thought but for some reason I don't have this checkbox:

communityquest2.png

shraddha_g
Honored Contributor III

Re: Visualization issue - Line Chart

are you using any extension for this

plu
Contributor III

Re: Visualization issue - Line Chart

Hi Aviad,

I also just realized it. The check box for null value on the second dimension is gone when using a continuous axis. I expect it to be gone on the first dimension, but not on the second. I'm about to file a bug on it.

But in the meantime you would have to modify your expression/dimensions so that no null values are included. Like replacing null with 0.

Sorry about this.

Regards,

Patrik.

satheshreddy
Contributor III

Re: Visualization issue - Line Chart

Hi Aviad,

Please Share your sample file, its better to find easily solution.

Regards

Sathish

aviadbein
New Contributor II

Re: Visualization issue - Line Chart

Thanks!