Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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,

Alison

5 Replies
ahaahaaha
Honored Contributor

Re: Problems With Dates

Hi,

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

Regards,

Andrey

Not applicable

Re: Problems With Dates

Hi Andrey,

Thank you for your response.

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

ahaahaaha
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.

jaimeaguilar
Valued Contributor II

Re: Problems With Dates

Hi,

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

regards

Community Browser