Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

difference of dates

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?!

1.JPG.jpg

Tags (1)
1 Solution

Accepted Solutions

Re: difference of dates

Try below

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


Regards

ASHFAQ

2 Replies

Re: difference of dates

Se mese anno chiusura è una dimensione modificala scrivendo:

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

Fammi sapere

Re: difference of dates

Try below

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


Regards

ASHFAQ

Community Browser