Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

problem with duplicate dates

in the source database- we have 1 field with date and time.

In script I try to make form this field 2 fileds - 1- date and 2- time,

but the proble is that QV creates from 1 to 8 same values of date.

for example many values of 31.08.2011

how to tell QV to make only 1 date value for all data with the same date?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Dmitry,

I do not open attchements, so the following is just my guess.
If you have two values:
Oct 28 2011 10:30
Oct 28 2011 10:40
And, you format it as date:
date(<datetimefield>)
You get two "values of the same date" because the undelying data is different.  To make it "real" date, you have to use integer part of your field as date, and fraction part as time:
date(floor(<datetimefield>)) as Date
time(frac(<datetimefield>)) as Time

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Dmitry,

I do not open attchements, so the following is just my guess.
If you have two values:
Oct 28 2011 10:30
Oct 28 2011 10:40
And, you format it as date:
date(<datetimefield>)
You get two "values of the same date" because the undelying data is different.  To make it "real" date, you have to use integer part of your field as date, and fraction part as time:
date(floor(<datetimefield>)) as Date
time(frac(<datetimefield>)) as Time

Not applicable
Author

Great thanks