topic Re: Line chart not showing zero values in QlikView

Line chart not showing zero values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

The expression used is: Count(Status).

As you can see in the picture, whenever there's a second without information, the line doesn't go down to zero and doesn't show the "0" value above either. How can I make this happen?

Any lacking information please ask me.

Thanks in advance.

Re: Line chart not showing zero values

Anonymous — Thu, 05 Jul 2018 18:17:33 GMT

Hi leonardo

Try setting show zero values in presentation tab.

Re: Line chart not showing zero values

joseph_morales — Thu, 05 Jul 2018 18:30:04 GMT

Try this.

Re: Line chart not showing zero values

Anonymous — Thu, 05 Jul 2018 18:31:31 GMT

Already done, doesn't work.

Re: Line chart not showing zero values

Anonymous — Thu, 05 Jul 2018 18:33:08 GMT

It's exactly like yours already, doesn't work...

Re: Line chart not showing zero values

vishsaggi — Thu, 05 Jul 2018 18:54:31 GMT

Can you share your qvw sample file if possible?

Re: Line chart not showing zero values

Anonymous — Thu, 05 Jul 2018 19:06:54 GMT

Unfortunately I cannot because it has confidential information, but I can provide you a few things, what do you need?

Re: Line chart not showing zero values

vishsaggi — Thu, 05 Jul 2018 19:09:05 GMT

You can scramble the data using 3 simple steps and then upload your qvw if possible. Read below for instructions:

can you show what your Axes tab looks like in properties window?

https://community.qlik.com/docs/DOC-1290

Re: Line chart not showing zero values

Anonymous — Thu, 05 Jul 2018 20:04:12 GMT

There you go. Just reinforcing what I need, each second has to show a value for each line, even if this value is zero.

Thanks in advance.

Re: Line chart not showing zero values

vishsaggi — Thu, 05 Jul 2018 21:16:05 GMT

Are you expecting this?

Re: Line chart not showing zero values

Anonymous — Fri, 06 Jul 2018 12:12:46 GMT

Not really... Let me take the "Desfeita" line as example:

In seconds 11:00:07, 11:00:09, 11:00:10 etc. the expression "Count(Status)" returns no value, and the line chart ignores these seconds and goes to the next second that has a value. I need all these seconds without a value to show "0" (see the picture I just made)

Re: Line chart not showing zero values

vishsaggi — Fri, 06 Jul 2018 12:56:38 GMT

‌ok let me look at it. Will get back later.

Re: Line chart not showing zero values

vishsaggi — Fri, 06 Jul 2018 17:43:41 GMT

Did you generate missing timestamps?

Check here:

Generating Missing Data In QlikView

Re: Line chart not showing zero values

Anonymous — Tue, 10 Jul 2018 12:22:25 GMT

Yes I did, importing an excel file and merging it (the excel file countains all timestamps).

Re: Line chart not showing zero values

SanAsh — Tue, 22 Mar 2022 19:07:42 GMT

Hi vishsaggi,

Did you reach a solution to this? i'm facing the same problem..

Re: Line chart not showing zero values

Mr_H_Huang — Mon, 04 Mar 2024 14:58:05 GMT

My solution is to add an additional 'Dummy Line' next to the line where we want to show with 0 value.

My case is a line chart, I have the 0 value in measure (which is a set analysis) that comes with valid dimension as YEAR & WEEK. However the QlikView line chart just skips the 0 value and dimension. If for example measure value is 0 in year 2023 week 35, the line chart goes from week 34 to week 36 and skips week 35. If I select week 35, I can see the value is 0, but the dimension is '-' which means null I suppose.

My solution is to add a very similar but simplified additional expression next to my original measure's expression. The setting/configuration remains the same for the original measure's expression. Then we uncheck all "Display Options" (like bar, line), and we check "Invisible" for the newly added additional expression.

Original expression, If it is for example
COUNT( {< flag_a ={'1'}, flag_b ={'0'} >} DISTINCT employee_no)

Then your additional expression could be like below. If it is the "flag_a ={'1'}" causing the 0 value could not be shown.
COUNT( {< flag_b ={'0'} >} DISTINCT employee_no)

Before applying the solution:

After applying the solution: