Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

[Added a screenshot] Graphic and "unique" date => Need help

Hi everyone

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)

- ID

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 :

03/04/2012

05/04/2012

05/04/2012

05/04/2012

06/04/2012

... etc

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 ...

Benoit

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: [Added a screenshot] Graphic and "unique" date => Need help

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()

Date(Floor(MY_FIELD),'DD/MM/YYYY')

You're welcome

View solution in original post

1 Reply
Highlighted
Not applicable

Re: [Added a screenshot] Graphic and "unique" date => Need help

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()

Date(Floor(MY_FIELD),'DD/MM/YYYY')

You're welcome

View solution in original post