topic Re: difference of dates in QlikView

difference of dates

Fri, 20 Jun 2014 08:04:27 GMT

hi!

i'm working on this pivot table and i want to create a new column with the difference, expressed in number of month, between the column called "mese anno chiusura" and "mese anno apertura", but as you can see there are some cells that not contain dates because the cases are still open; so how can I get a new column with the difference between the dates and where there is no date in column called "mese anno chiusura" is reported "open" in the new column?!

Re: difference of dates

alexandros17 — Fri, 20 Jun 2014 08:11:59 GMT

Se mese anno chiusura è una dimensione modificala scrivendo:

If(IsNull([mese anno chiusura]), 'Open', [mese anno chiusura])

Fammi sapere

Re: difference of dates

ashfaq_haseeb — Fri, 20 Jun 2014 08:14:41 GMT

Try below

If(IsNull([mese anno chiusura]), 'Open', [mese anno Apertura]-[mese anno chiusura])

Regards

ASHFAQ