Discussion board where members can get started with QlikView.
I'm french, and noob with qlikview, so I'll do my best to explain my problem.
I've got the PDF document (934 pages in english), but I don't find the answer in it 😕
I have some simple datas from an sql table, that I charged in qlikview, no problem with that.
SQL fields :
- Date (yyyy/mm/dd hh:i:s)
I have to build a graphic that count the ID per date DD/MM/YYYY, without h:i:s.
But, even with the dimension =date([Date de création], 'DD/MM/YYYY'), the graphic won't "join" the same date.
In the X axe it's :
Because in the datas, there are 05/04/2012 05:10:50 , 05/04/2012 07:13:21 etc ...
CF : The screenshot
How can I do, to have uniques dates on the X axe ?
Thank you if you understand what I mean, and more thank you if you have an answer
Tell me if you need more infos : Screenshot, load script etc ...
The community won't/can't answer me ?
No problem, I've found it by myself.
To those poor guys with the same problem, the answer is : Floor()
View solution in original post