Flag date differences

[ranibosch]

good day,

please find attached data with required results.

i have no idea how to populate the pivot table in qlikview to get my desired results.

[YoussefBelloum]

Hi,

you can try this on the script:

if(len(trim(close_date))<>0, close_date - open_date) as Difference_days_open_vs_close_date,

if(len(trim(close_date))=0,Date(today()) - open_date) as Difference_days_open_vs_today_date,

PS: make sure your Open_date and Close_date are already evaluated as dates with the correct format, otherwise you will need to use Date#() and Date() functions