topic Re: How to load distinct dates? in QlikView

How to load distinct dates?

Thu, 14 Mar 2013 15:35:41 GMT

Hi All,

My table is having one column only as Date

Date

3/13/2013

3/14/2013

I want to load only distict dates is another table like:

Date

3/13/2013

3/14/2013

How to do this?

Thanx in advance..

Re: How to load distinct dates?

Thu, 14 Mar 2013 15:36:23 GMT

LOAD DISTINCT

Date

FROM Table;

Re: How to load distinct dates?

jagan — Thu, 14 Mar 2013 15:40:17 GMT

Hi,

try

LOAD

DISTINCT Date

FROM DataSource;

Regards,

Jagan.

Re: How to load distinct dates?

Thu, 14 Mar 2013 15:52:00 GMT

It is not working. Pl find attched application.

Re: How to load distinct dates?

Thu, 14 Mar 2013 15:57:43 GMT

Try with this. your dates have decimals (hours, minutes, etc, are difrerentes)

Audits:

LOAD

Date(DayStart(Timestamp)) as Calendar_Date

FROM Logs\Audit*.log

(txt, utf8, embedded labels, delimiter is '\t', msq)

where Date(Timestamp)>='01/01/13';

Ricardo

Re: How to load distinct dates?

CELAMBARASAN — Thu, 14 Mar 2013 17:49:08 GMT

Hi,

You can use like this way also

Audits:

LOAD

Date(Floor(Timestamp)) as Calendar_Date

FROM Logs\Audit*.log

(txt, utf8, embedded labels, delimiter is '\t', msq)

where Date(Timestamp)>='01/01/13';

Before doing this type of operation make sure that you don't need time(hours and minutes) for analysis.