topic Re: help with calendar variable in QlikView

help with calendar variable

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have a problem with a couple of calendars. they are assigned to variables (vFromDate and vToDate). the format of the date is DD/MM/YYYY but when i select a date from the calendars the result of the variable is in the number format.

i then have a button which applies the From/To dates to the Date field but it isn't working because of the formats.

I am unsure on what to do to correct this as the date format is correct, it just seems that the calendars are applying the wrong format to the variables.

i have attached an example, can anyone offer any advice please?

Re: help with calendar variable

jonathandienst — Tue, 03 May 2016 10:10:32 GMT

You can set the format on the number tab of the calendar object properties, or the number tab of the document properties (select Variables in the drop down at the left top corner).

Re: help with calendar variable

sunny_talwar — Tue, 03 May 2016 10:11:44 GMT

I guess I don't understand the issue. Would you not be able to use this for your expression?

='vFromDate' &'

'&Date(vFromDate)

Re: help with calendar variable

hopkinsc — Tue, 03 May 2016 10:16:03 GMT

Hi, those text boxes were added for visual confirmation only. i need the variables to be the DD/MM/YYYY format automatically, so when the 'Apply Date Range' button is clicked it would apply the variable values to the Date field. at the moment that doesnt work because of the different formats

Re: help with calendar variable

sunny_talwar — Tue, 03 May 2016 10:19:32 GMT

May be use this as your search string:

='>=' & Date(vFromDate) & '<=' & Date(vToDate)

Re: help with calendar variable

Mahamed_Qlik — Tue, 03 May 2016 10:32:11 GMT

Hi hopkinsc,

You can try this.

-Whever you will use the vFromDate variblae, just convert it to proper date format as below :

='vFromDate' &'

'&Date(vFromDate,'DD-MM-YYYY')

Regards,

Mahamed