Explanation of two expressions returning zero values and when are they shown in a chart.

[Morgoz]

Hello,

I'd like to know what is the difference, or why this expression:

count(if(CANAL = 'Sin Canal', ID_DQ_FACTS))

Does not displays in a line chart the same way as this:

count({<CANAL = {"Sin Canal"}>}ID_DQ_FACTS)

The first shows like this:

(Shows zero values)

And the second shows like this:

(Zero values have disappeared).

Thank you!

[canerkan]

Hi Morgoz,

i guess your If function in your first expression is just testing all your datasets for your condition and is replacing the value of those datasets that do not meet your condition with 0, while your second expression is reducing your datasets to those that meet your condition (set expression can be understand as a filter). That means the dates, where your condition is no met are not available anymore and therefore are missing in your chart.

Hope this answers your question.

Regards,

Can