Count Specific - In line chart

[#1]

Hi all,

I'm trying to show average amounts per time in a line chart by summing the amounts per time and divide it by the number of days. However, something is fishy, pls see below. For instance, When choosing 3 (distinct) dates, these two graphs are showing different values. Seems very odd to me. Any ideas?

[Gysbert_Wassenaar · Accepted solution]

Is your Date field a key field that links one or more tables? If so, qlikview cannot know from which table it should count the Date values. You can get undefined behaviour in that case. The solution is to use another field from the table over which you want to count.

[#3]

Hi Gysbert,

The below Is all I got.

And im counting the Date field.

Thanks in advance,

Olle

Text(Date(SettlementTime, 'YYYY-MM-DD')) As Date

[#4]

Found the problem. Issues with the underlying data.

//O