Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
ashfaq_haseeb

Try below

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


Regards

ASHFAQ

View solution in original post

2 Replies
alexandros17

Se mese anno chiusura è una dimensione modificala scrivendo:

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

Fammi sapere

ashfaq_haseeb

Try below

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


Regards

ASHFAQ

View solution in original post