topic Re: Date Field Filter in QlikView

Date Field Filter

techvarun — Thu, 22 Aug 2013 07:32:55 GMT

I have a date field with timestamp in it. so in list box am getting N number of entries i need to show only one entry for the day

Regards & Thanks in advance

Re: Date Field Filter

alexandros17 — Thu, 22 Aug 2013 07:40:27 GMT

IN the listbox use the expression (at the bottom of fields list) and set date(myfield), in this way the list box shows unique values for dates

Re: Date Field Filter

techvarun — Thu, 22 Aug 2013 07:48:02 GMT

Sorry dude still it is showing all the values

Re: Date Field Filter

alexandros17 — Thu, 22 Aug 2013 07:51:07 GMT

try date(myDate,'dd/MM/yyyy')

Re: Date Field Filter

tresB — Thu, 22 Aug 2013 07:56:41 GMT

I would suggest to use MakeDate() function. Date() function formats the value while the underlaying numric value remains same.

Re: Date Field Filter

techvarun — Thu, 22 Aug 2013 07:56:54 GMT

Still its showing the same

is there any way to fetch unique date values from qvd itself?

Re: Date Field Filter

kaushiknsolanki — Thu, 22 Aug 2013 08:01:15 GMT

Hi,

Try this.

Date(Floor(Date)) as Date

You are seeing this because you have timestamp also in the date, so you need to remove the timestamp and thus the floor function is needed as shown in above example.

Regards,

Kaushik Solanki

Re: Date Field Filter

Thu, 22 Aug 2013 08:01:35 GMT

I would advise you do make a new field in the back end Date(Floor(DateTimeField),'DD/MM/YYYY') AS DateField

Re: Date Field Filter

techvarun — Thu, 22 Aug 2013 08:09:17 GMT

"Floor(Date) as Date" Used this in Load level and resolved the problem

Many Thanks