This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
please find attached data with required results.
i have no idea how to populate the pivot table in qlikview to get my desired results.
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