topic Re: Current Selection - Date in QlikView

Current Selection - Date

priyarane — Thu, 26 Feb 2015 14:30:53 GMT

Hi Experts,

I have listbox with date - =Date(TE_AS_OF_TMS) and Whene ever I select date for ex 26-02-2015 and then in Current selections its looks like 44555(Ex) so, how can I Show Date in Current selections.

Thank you

Re: Current Selection - Date

giakoum — Thu, 26 Feb 2015 14:33:19 GMT

read it as date in your script

Re: Current Selection - Date

menta — Thu, 26 Feb 2015 14:34:21 GMT

You can load the field directly as date with your format or you can set the view of the field by -->Settings-->Number

selct the field and change the display mode

Re: Current Selection - Date

priyarane — Thu, 26 Feb 2015 14:35:34 GMT

Script I can't touch now, could you please help in how to show date in Current selections

Re: Current Selection - Date

buzzy996 — Thu, 26 Feb 2015 14:36:26 GMT

in ur calender object

1. date(mTE_AS_OF_TMS)

2. Number tab on calendar object--choose DATE radio button and type format.

Re: Current Selection - Date

Anonymous — Thu, 26 Feb 2015 14:36:32 GMT

Hi,

Use =Date(TE_AS_OF_TMS,'DD/MM/YYYY')

or in script:

Date(TE_AS_OF_TMS,'DD/MM/YYYY') as Date

Regards

Neetha

Re: Current Selection - Date

priyarane — Thu, 26 Feb 2015 14:40:50 GMT

Thanks Carlo,

Settings-Docproperties-Number-

Re: Current Selection - Date

priyarane — Thu, 26 Feb 2015 14:42:55 GMT

Thanks Neeta for reply, but what ever you write(date format) but current select will appear as script data. And as Carlo said,

Settings-Docproperties-Number-