Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to store date value from calendar to a variable

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

1 Solution

Accepted Solutions
fosuzuki
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

3 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

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

shane_spencer
Specialist
Specialist

Awesome. No idea you could do that.

Scott2
Contributor III
Contributor III

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!

 

088dea25-bca4-40e2-9def-5fabe186d824.png