topic Re: KEY TABLE - problem in QlikView

KEY TABLE - problem

adiarnon — Tue, 22 Jul 2014 13:27:35 GMT

hi,

i created a kay table.

one of the fields in this table is date

when im creating a list box of the date field i see duplications:

like-

1/1/12

2/1/12

3/1/12

...

can someone halp me to understand why?

i need that each value will be shown once...

Re: KEY TABLE - problem

jonathandienst — Tue, 22 Jul 2014 13:31:39 GMT

This is most likely because those dates contain a time portion which is hidden by the format. Test this by using Num(date) in a list box - you will see a fractional part which is the time.

Load with the Floor() function to get a clean date or use Date(Floor(date)) in the list box.

HTH

Jonathan

Re: KEY TABLE - problem

MayilVahanan — Tue, 22 Jul 2014 13:34:42 GMT

Try like this'

Load Date(floor(Datefield)) As Datefield ...

Hope it helps