Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Date (in date format) + days(in numbers)

Hi all,

Please help me solve this. How can I put in the F(x) as in above title as measure?. I want to subtract manufacturing date (dd-mm-yy) with shelf life (days in figure)


what I did is

[Manufacturing date]-[Shelf Life]..which if to interpret, eg:

(01-01-2017) + 720

but it seems that qlik sense can't read it. your respond is highly appriciated.

6 Replies
Highlighted

Re: Date (in date format) + days(in numbers)

May be your date is not read as date by Qlik Sense..... Read these articles here

Why don’t my dates work?

Get the Dates Right

Highlighted
Not applicable

Re: Date (in date format) + days(in numbers)

so my fx should be fine?

Highlighted
Not applicable

Re: Date (in date format) + days(in numbers)

I ma using qliksense desktop by the way

Highlighted

Re: Date (in date format) + days(in numbers)

Doesn't matter if you are Qlik Sense desktop or Qlik Sense enterprise or QlikView. The basic of dates remain the same.

Highlighted
Not applicable

Re: Date (in date format) + days(in numbers)

Alright. It fixed. thank you

Highlighted

Re: Date (in date format) + days(in numbers)

Awesome, please close this thread by marking correct and helpful responses

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny