Count in Line Graph counting incorrectly

Tue, 10 Apr 2012 21:29:37 GMT

What did I do wrong here? I have a list of activities with start dates 10/12/12 through 11/12/12. When I ask the chart to count the starts on each date, it staggers the graph. There should be only one data point between days, but for some reason it waves. Any body got an idea on this one?

Thanks,

Heydar

Count in Line Graph counting incorrectly

swuehl — Tue, 10 Apr 2012 22:48:24 GMT

Your BL Start is still a timestamp. You formatted the field as date (without time), but the internal representation still keeps the time (check the numerical representation e.g. by adding an expression num([BL Start]) to a list box with BL Start.)

Try creating a real date by applying daystart() to your field, maybe like

LOAD

...

Date(daystart([(*)Start]),'DD.MM.YYYY') as [BL Start],

....

Hope this helps,

Stefan

topic Count in Line Graph counting incorrectly in QlikView

Count in Line Graph counting incorrectly

Count in Line Graph counting incorrectly