Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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