Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

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

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

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

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

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

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.

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

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

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

Community Browser