Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
agastya
Creator
Creator

YoY and Mom growth calculation on line chart

Hello all,

I want show YOY and MOM expression(different chart) in line chart .

 

Using 2 dimensions

Customer and year

Expression:-

((COUNT(Aggr(IF(COUNT({<P_DWG -={' '}>}Distinct Drawing_root_Key)=1, 1),P_DWG,New_Primary_Project)) )/
Count({<P_DWG -={' '}>}DISTINCT P_DWG)
)

 

 

 Month Current year vs Previous year current month

 Current Year vs Previous Year

 

 

!!quite urgent thank you

@sunny_talwar 

0 Replies