topic Re: graph error in QlikView

graph error

master_student — Fri, 16 Sep 2016 14:56:55 GMT

Hello community,

I have a date field in my database that containes date and time as you can see bellow :

I would like to create a graph using that date but the problem as you can see bellow is that the same date is reapeated many times

Any idea please??

Thanks

sunny_talwar — Fri, 16 Sep 2016 14:58:15 GMT

May be use this as your dimension:

Date(Floor([Date de creation]))

sunny_talwar — Fri, 16 Sep 2016 14:59:23 GMT

Alternatively you can also create a only date field in the script:

LOAD Date(Floor([Date de creation])) as DateField,

[Date de creation]

FROM ....

and then use DateField as your dimension

master_student — Fri, 16 Sep 2016 15:42:46 GMT

Thanks Sunny.