Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

date repeatation

Hi all,

In the attached .QVF file. you have sheet with name "date".

where you can see the table which has dates. dates are repeated many times. i need each date only once.

Please help on it.

Thanks,

Pramod

Tags (1)
1 Solution

Accepted Solutions

Re: date repeatation

I can't check your document right now, but check that your date values do not contain time fractions. If necessary use the floor function to cut of the time fractions:

MyTable:

LOAD ...some_fields...,

     date(floor(MyDateField),'M/D/YYYY') as MyDateField

FROM ....


talk is cheap, supply exceeds demand
10 Replies

Re: date repeatation

I can't check your document right now, but check that your date values do not contain time fractions. If necessary use the floor function to cut of the time fractions:

MyTable:

LOAD ...some_fields...,

     date(floor(MyDateField),'M/D/YYYY') as MyDateField

FROM ....


talk is cheap, supply exceeds demand

Re: date repeatation

Try:

LOAD Distinct

santhoo_san
Contributor II

Re: date repeatation

change your date format. It has time stamps, if you remove time stamp from the date, you will get unique date in the list.

date(floor(CanonicalDate))

Not applicable

Re: date repeatation

Hi,

I checked i don't have timestamps for date fields.

Thanks,

Pramod

santhoo_san
Contributor II

Re: date repeatation

Hi See the date stamp in your date field

Capture.JPG

Not applicable

Re: date repeatation

Hi,

You can see the attached image.

weekday.png

Thanks,

Pramod

santhoo_san
Contributor II

Re: date repeatation

Hi Pramod, if you apply date condition in the above table,

date(CanonicalDate,'DD-MMM-YYY-HH-mm-ss') you will be able to see different time stamps in  the same date field.

to eliminate the time stamp you can use floor() function

Not applicable

Re: date repeatation

Hi Gysbert Wassenaar,

If possible once check with above.qvf file. In sheet i have used weekdays  to show the data.

My table contains only the data what it is showing in monday. but i don't know from where the other days data is getting.

Please check and help to solve on it.

Thanks,

Pramod

Re: date repeatation

As others have pointed out, you do have time fractions in some of your dates. You can see that by using

=timestamp(CanonicalDate)

in your filter pane.

Floor() all your CannonicalDate values, including the ones you load into the mapping table.

-Rob