SUM aggregation function skips data rows with value "0"

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

Hi all,

I have a not too difficult table with 3 columns from a tool output:

timestamp, block, Error

there are different checks of the tool at one timestamp per block, thus a result can be (here just shown for one block:

timestamp, block, Error
t1, block_A, 0
t1, block_A, 1
t2, block_A, 0
t2, block_A, 0

I need to have the total number of errors over time (with time axis continuous) so I would need to add for t1 1+0 = 1 and for t2 0+0 = 0 and I'd like to plot that result

here the issue:
in the plot or table using timestamp & block as Dimensions and using sum(Error) the data shows up for all blocks that have for all time points at least 1 Error, but once we have 0 Errors the data is not shown (not in the table or the plot).
faking the data and using "0.000001" (a very small number) instead of "0" QlikView will show the correct plot and table.

Somehow I must be assuming something wrong coming from other prgramming languages vs. what Qlikview sum does in the chart/table

thanks for your help, Werner

Re: SUM aggregation function skips data rows with value "0"

jensmunnichs — Fri, 28 Jun 2019 14:38:12 GMT

Hi,

Qlikview automatically hides data where the result of all expressions is 0. You can change this in the 'Presentation' tab in the chart properties (See pictures below, slightly different per chart type).

Line chart:

Straight table:

Hope this helps!

Re: SUM aggregation function skips data rows with value "0"

WernerG1604 — Fri, 28 Jun 2019 14:47:27 GMT

Hi,

PERFECT - that did the job - THANK YOU!

topic Re: SUM aggregation function skips data rows with value "0" in QlikView

SUM aggregation function skips data rows with value "0"

Re: SUM aggregation function skips data rows with value "0"

Re: SUM aggregation function skips data rows with value "0"