Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

XML file and data organization

Hi everybody,

In the project attached I got 2 tables named "Date" and "Heure" (from XML file). The problem is that I get many times the same date in the field "Date". What I would like to get is to clik on one date and get all "heure" of this "date". In fact I don't want the same value in "Date".

Thank you very much

1 Solution

Accepted Solutions
disqr_rm
Partner - Specialist III
Partner - Specialist III

Use following to load date field. The problem is that the date field is actually a timestamp field and with time, they are unique values. With daystart function, if takes 00:00:00 as the time so you get same dates (of same time).

LOAD

Date(daystart(date)) as Date,

....

View solution in original post

1 Reply
disqr_rm
Partner - Specialist III
Partner - Specialist III

Use following to load date field. The problem is that the date field is actually a timestamp field and with time, they are unique values. With daystart function, if takes 00:00:00 as the time so you get same dates (of same time).

LOAD

Date(daystart(date)) as Date,

....