Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ranibosch
Creator
Creator

Flag date differences

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.

1 Reply
YoussefBelloum
Champion
Champion

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