How to plot sales growth rate by year ?

[#1]

Hi All

Jason just help me get the sales growth rate using Table. see the below link :-

http://community.qlik.com/thread/100314

Now i need to go one step further is to plot the growth rate number using chart.

I have try , the Growth rate does not able to display on bar chart.

Paul

[#2]

Hi Sir

I have try to use the above function , but the % bar does not able to display on the chart.

Paul

[Anonymous · Accepted solution]

Paul

You qvw is actually working but the sum(sales)expression which is marked as invisible is making it think it has values of 1+ million, and setting the axis scale accordingly but not displaying the large sales values.... as it is marked invisible.

The %'s are an order of magnitude smaller and so are such tiddly blips they cannot be seen.

Solution: Remove your sum(sales)expression

Best Regards,     Bill