Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calendar Variable

Hi!


I have a problem with Calendar Variable which it is an extension from Qlik Branch (Qlik Branch). the date format is DD/MM/YYYY, and in my project I need to add the time (
DD/MM/YYYY hh:mm:ss).

How can I do that? moreover, In some queries I need a fixed time I mean for example the From Date: (DD/MM/YYYY 00:00:00)
and and for the To Date (
DD/MM/YYYY 23:59:59). I tried to add the time (00:00:00) in a new variable but the problem the date converted to a number and the value appear like [for example ] (00994568415 00:00:00). Please see the attached pic for more explanation.

Thanks.

4.png

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I don't understand what you're trying to do. Can you post a small Qlik Sense app that illustrates the problem?


talk is cheap, supply exceeds demand
Not applicable
Author

I have posted a screen shot photo. Do you mean to upload a qlik sense file for the problem?

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Do you mean to upload a qlik sense file for the problem?

Yes, exactly.


talk is cheap, supply exceeds demand