topic Re: display days in QlikView

display days

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am calculating the days but am getting the wrong out output

Re: display days

Frank_Hartmann — Mon, 11 Sep 2017 10:19:42 GMT

Load *,

num(Date#('07/19/2017','MM/DD/YYYY'))-num(Date#(OpenDate,'MM/DD/YYYY')) as [Open Days]

num(Date#('07/19/2017','MM/DD/YYYY'))-num(Date#(Update Time,'MM/DD/YYYY')) as [Last Updated Days]

Re: display days

Anil_Babu_Samineni — Mon, 11 Sep 2017 10:20:07 GMT

If [Open Date] is the format of DD/MM/YYYY then try like below

MakeDate(2017, 07, 19) - Date([Open Date], YYYY-MM-DD) as [Open Days],

MakeDate(2017, 07, 19) - [Update Time] as [Last Updated Days];

Re: display days

pathiqvd — Mon, 11 Sep 2017 10:20:51 GMT

convert '7/19/2017' to date format

Data:

Load *, Date(date#('7/19/2017','MM/DD/YYYY'))-[Open Date] as [Open Days],

Date(date#('7/19/2017','MM/DD/YYYY'))-[Update Time] as [Last Updated Days];

Re: display days

soniasweety — Mon, 11 Sep 2017 10:39:28 GMT

its not working same result came

Re: display days

Anil_Babu_Samineni — Mon, 11 Sep 2017 10:41:09 GMT

My expressions may frequent to you. Will you check?

Re: display days

soniasweety — Mon, 11 Sep 2017 10:43:06 GMT

this is also not giving anil

Re: display days

Anil_Babu_Samineni — Mon, 11 Sep 2017 10:44:27 GMT

May be share sample data in excel?

Re: display days

Anonymous — Mon, 11 Sep 2017 11:08:16 GMT

Try using this expression

LOAD

Open_Date,

Update_Date,

DayNumberOfYear(Date('01/03/2017','DD/MM/YYYY') - Date(Open_Date,'DD/MM/YYYY')) as Open_Days

FROM

You_Table

Hope This helps.

Re: display days

pathiqvd — Mon, 11 Sep 2017 11:08:19 GMT

Data:

Load *,

Date(date#('7/19/2017','MM/DD/YYYY'),'MM/DD/YYYY')-Date([Open Date],'MM/DD/YYYY') as [Open Days],

Date(date#('7/19/2017','MM/DD/YYYY'),'MM/DD/YYYY')-Date([Update Time],'MM/DD/YYYY') as [Last Updated Days];

Re: display days

its_anandrjs — Mon, 11 Sep 2017 16:59:17 GMT

It seems you need this on the Load script then try this way to load on the Load Script

Load *,

Interval( Date(Date#('7/19/2017','M/DD/YYYY'),'M/DD/YYYY') - Today() ,'D') as [Open Days],

Interval( Date(Date#('7/19/2017','M/DD/YYYY'),'M/DD/YYYY') - Today() ,'D') as [Last Updated Days]

Replace this lines for your fields and let me know what result you get.

Or May be this or change the field name please in your load script

Interval( Date(Date#('7/19/2017','M/DD/YYYY'),'M/DD/YYYY') - Today() ,'DD') as [Open Days],

Interval( Date(Date#('7/19/2017','M/DD/YYYY'),'M/DD/YYYY') - Today() ,'DD') as [Last Updated Days]

Re: display days

soniasweety — Tue, 12 Sep 2017 06:29:11 GMT

thanks anand,I will check and update you