topic Re: how to store date value from calendar to a variable in QlikView

how to store date value from calendar to a variable

Thu, 12 Apr 2012 07:08:15 GMT

Hi Experts,

Please please help me in storing a date picked value from calendar object to a variable in 'YYYY-MM-DD' format.

I'm stuck with this from long time and its now urgent to resolve it. Waiting to hear solutions.

Note: Using Personal Edition.

Thanks in Advance,

Pavan

how to store date value from calendar to a variable

fosuzuki — Fri, 13 Apr 2012 03:54:38 GMT

1. Create a variable vDate and set its number format as Date 'YYY-MM-DD'. Go to Document Properties > Number > Variables > Select your variable > Select Date option

2. create a calendar object using the variable vDate. Go to Calendar Properties > General > Select Variables option > Select the variable vDate

Hope this points you in the right direction

Fernando

Re: how to store date value from calendar to a variable

shane_spencer — Tue, 27 Mar 2018 09:47:23 GMT

Awesome. No idea you could do that.

Re: how to store date value from calendar to a variable

Scott2 — Mon, 21 Aug 2023 15:02:31 GMT

Hi Fosuzuki,

Hope you are well!

I am new to Qlik and am trying to do the same thing in this thread to "create a calendar object using the variable vDate" but i am trying in QlikSense rather than Qlikview and I don't see any similar option to in QlikSense "date picker" object. See below screenshot - it seems one can only pass a Date field that is from one of my data tables.

Any suggestions on how to achieve this? Much appreciated!