Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

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

Re: Calendar Variable

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

Re: Calendar Variable

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

Re: Calendar Variable

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

Yes, exactly.


talk is cheap, supply exceeds demand
Community Browser