topic Re: Layout issue dates in selection in QlikView

Layout issue dates in selection

danosoft — Wed, 26 Jan 2022 10:06:30 GMT

As shown in the photo, the dates in the "current selections" are shown to me as a number and not in date format (picture 1), it is possible to put them in date format as I see them when I go to select them (picture 2)

Re: Layout issue dates in selection

MarcoWedel — Wed, 26 Jan 2022 11:33:05 GMT

you have to already format the field as a date in your load script, e.g.:

LOAD Date(whatever expression you are currently using for DATA_EMISSIONE) as DATA_EMISSIONE

Re: Layout issue dates in selection

danosoft — Thu, 27 Jan 2022 08:28:04 GMT

Thanks MarcoWedel, but sorry... the problem is only in the "current selection" , in the "select box" i see already well

Re: Layout issue dates in selection

Marcel_Garcia — Thu, 27 Jan 2022 11:52:29 GMT

Hi Danosoft.
Have you tried DATE(field_name, 'DD/MM/YYYY')?

Re: Layout issue dates in selection

danosoft — Thu, 27 Jan 2022 15:59:57 GMT

Sorry but where?

In Current Selection i can't put that

Re: Layout issue dates in selection

MarcoWedel — Thu, 27 Jan 2022 18:00:34 GMT

So you tried using Date() in your LOAD statement and nevertheless did not get the expected result or you did not try because you believe that your issue is restricted to the current selections box?

Can you please post a preview of this field in the table viewer as well as the number format setting of your ListBox?

thanks

Re: Layout issue dates in selection

danosoft — Fri, 28 Jan 2022 07:59:52 GMT

"or you did not try because you believe that your issue is restricted to the current selections box?" Yes right

In the preview i see the number

in my list box i see it well, but yes i use date format there

in my "current selection" i see the number

Re: Layout issue dates in selection

MayilVahanan — Fri, 28 Jan 2022 10:23:01 GMT

Hi Danosoft,

As suggested by Marco, you need to change the format in the script part in order to fix the problem.

Load Date(UrDateField, 'DD/MM/YYYY') as UrDateField from ursource;

Then it will fix auto in the current selections box.

Re: Layout issue dates in selection

MarcoWedel — Fri, 28 Jan 2022 18:31:19 GMT

The current selections box is showing you the format that your field actually is loaded with.
If you change the format that is generated during the load, you don't have to define a special format in the ListBox while also getting your desired format in the current selections box.