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: 
Not applicable

how to show growth percentage year on year in line chart ?

Hi Friends,

Please find the attached QVW. How to show growth or decrements on year year  segment wise.

So I need to show Segment A variation by year wise ,Segment B  and Segment C. Please do modifications in line chart.

5 Replies
sunny_talwar

You want to see YoY growth just for Segment A or all Segments on the line chart?

sunny_talwar

Is this what you want?

Capture.PNG

Expression for Growth:

Sum(sales)/Above(TOTAL Sum(sales), Count(TOTAL <Year> segment))-1

Also attaching the your application for reference.

Best,

Sunny

Not applicable
Author

Hi Sunindia,

Thanks for your help. I need growth for all segments. I have tried this expression in scenario. I am getting error i.e., NO DATA TO DISPLAY.

sunny_talwar

Well I guess I would need to see your scenario to give you a better solution for your scenario, because the sample your prepared seems to work with expression I gave you, isn't it? Can you share a reduced version of your application or may be a more representative sample of your actual scenario to help you better?

Best,

Sunny

Not applicable
Author