Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Difference between Start and End Dates in Months as per Year

qlikwiz123_0-1609550662837.png

 

I need to show difference between Start Date and DATE in Months in such a way that the number of months divide as per the year.

For example,  for ID 1, 

ID, Year, Months

1, 2020, 1

1, 2021, 12

.....

 

QVW is attached. Any lead is appreciated 

Labels (1)
1 Reply
Anil_Babu_Samineni

One way is

Load ID, [Start Date], [Start Date] as DateField From T1;

Join

Load ID, [DATE], [DATE] as DateField From T1;

Create Chart like'

Dimension : ID

Dimension : Year(DateField )

Measure : Num(Month([Start Date])-Month(DATE))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful