Line chart not showing zero values

[Anonymous]

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.

[Anonymous]

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)

[vishsaggi]

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

[vishsaggi]

Did you generate missing timestamps?

Check here:

Generating Missing Data In QlikView

[Anonymous]

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

[SanAsh]

Hi vishsaggi,

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

[Mr_H_Huang]

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: