if translate from excel to qlikview

[0li5a3a]

Hi all,

How I can translae this formula from excel to qlikview load script?

=IF(B30="","",IF(P30="closed","",DAYS(NOW(),B30)))

I have the this folrmula in excel and

B30 is Date Raised,

P30 is Status

I want to use nested if to create a Open Age filed in load script.

Regards,

C

[shiveshsingh]

What is the work of this DAYS(NOW(),B30)?

and what about this condition, if B30 is null, then null..m i right?

[0li5a3a]

DAYS(NOW) is a function in excel to display the date today.

[0li5a3a]

And we do a calculation between today  minus the date when the order had been created.

[shiveshsingh]

=IF([Date Raised]="","",IF(Status="closed","",Today()))

Try this

[olivierrobin · Accepted solution]

hello,

maybe something like that  (keeping the name of the excel cells)

if(b30="",

"",

if(p30="closed",

"",

today()-b30

)

)

[shiveshsingh]

=IF([Date Raised]="","",IF(Status="closed","",Today()-[Date Raised]))

Make sure your [Date Raised] format matches with today()

[sasiparupudi1]

IF(Len(Trim(B30))=0,'',IF(P30='closed','',Date(Today()),B30))