topic Re: Display distinct date in list box in QlikView

Display distinct date in list box

Thu, 21 Mar 2013 14:43:55 GMT

Hi,

I am getting duplicate dates in a list box like this:

But I just want to show only distinct dates.

Do you know how to set it up?

Thanks in advance

MayilVahanan — Thu, 21 Mar 2013 14:49:01 GMT

Use

Load *, Floor(DateField) as DateField

from tablename;

Hope it helps

hic — Thu, 21 Mar 2013 14:50:24 GMT

These dates probably contain a time part also, that is hidden by the formatting. You need to create the field using Date(Floor(Date)).

HIC

Thu, 21 Mar 2013 15:08:58 GMT

Yes, you solution worked.

Thanks a lot..

On Thu, Mar 21, 2013 at 7:50 PM, Henric Cronström

Wed, 01 May 2013 13:39:32 GMT

Hi,

The following worked for me as an expression in the ListBox.

Date(floor(DATE_TIME_FIELD), 'MM/DD/YYYY')

Hope this helps someone.

Thu, 02 May 2013 05:44:54 GMT

Yes, I have used the same expression in my ListBox while following your

help.

Thanks...