Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
abc_18
Contributor

How to calculate # no of days

Hi,

I need to calculate a field called #days in Backorder.

field Order date is skey_date_order


So I can calculate the difference with today’s date, please suggest how can I achieve this?

Thanks

2 Replies
MVP
MVP

Re: How to calculate # no of days

Today()-skey_date_order

Highlighted
thevingo
Contributor

Re: How to calculate # no of days

Hi

try   Date#(Today(), 'DD/MM/YYYY') - Date#(skey_date_order , 'DD/MM/YYYY')

format DD/MM/YYYY depend on date format of field skey_date_order

You may have to change this.