topic XML file and data organization in QlikView https://community.qlik.com/t5/QlikView/XML-file-and-data-organization/m-p/315429#M116399 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>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".</P><P></P><P>Thank you very much</P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P></BODY></HTML> Fri, 20 May 2011 10:29:26 GMT 2011-05-20T10:29:26Z XML file and data organization https://community.qlik.com/t5/QlikView/XML-file-and-data-organization/m-p/315429#M116399 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>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".</P><P></P><P>Thank you very much</P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P></BODY></HTML> Fri, 20 May 2011 10:29:26 GMT https://community.qlik.com/t5/QlikView/XML-file-and-data-organization/m-p/315429#M116399 2011-05-20T10:29:26Z XML file and data organization https://community.qlik.com/t5/QlikView/XML-file-and-data-organization/m-p/315430#M116400 <HTML><HEAD></HEAD><BODY><P>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).</P><P></P><P>LOAD</P><P>Date(daystart(date)) as Date,</P><P>....</P></BODY></HTML> Fri, 20 May 2011 22:01:37 GMT https://community.qlik.com/t5/QlikView/XML-file-and-data-organization/m-p/315430#M116400 disqr_rm 2011-05-20T22:01:37Z