Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Not applicable

Problems With Dates

Hello All,

I would like your help.

I have a number of tables which have dates, like so:

Screenshot (90).png

Screenshot (91).png

And a master calendar that looks like so:

Screenshot (92).png

Yet, in the UI, only the dates coming from the merchandise income tables are showing up.

As you can see here:

Screenshot (93).png

Please can someone tell me why this is, and what can be done about it.

Thank you all in advance,


5 Replies
Honored Contributor

Re: Problems With Dates


Try use function Date() for field [Date]? Like this Date([YourDateExpression]).



Not applicable

Re: Problems With Dates

Hi Andrey,

Thank you for your response.

However, I believe I am already using the Date function.

Honored Contributor

Re: Problems With Dates

In the picture in MasterCalendar date field is used with the function Text(). May be Text() change to Date()?

Not applicable

Re: Problems With Dates

Hi Again,

Sorry, I misunderstood you.

Ok I have now done that and I get the following result:

Screenshot (94).png

So it's different but not better.


Re: Problems With Dates


the problem with the Date field is like it is already being said the date format. So in other words, no matter the number of functions you apply to your date, your outter function should be date, like this

Date(Monthstart($(vMinDate) + RecNo() -1)) as Date

Also, the num and text functions are not necessary nor useful in this case,

Date/Time functions could be a little confusing to get into them, but once you understand them you'll see how useful they are,

hope this helps