Is it possible to show by year,product growth rate and year growth in one line chart?

[adamgaox]

Hi All,

Is it possible to show the growth rate by year, product growth rate and total year growth rate in one line chart in expression directly?

I know we could add rows in the source data like 'Total' in product.

Due to in some scenario it's not easy to change in the backend, I just ask the possibilities of this.
I've attached my QlikView file.

Thank you very much.

Best Regards.

Jia-wen.

[swuehl · Accepted solution]

Maybe like attached, using an island table to create a dimension to branch into Product and TOTAL.

[jyothish8807]

You can do it my writing one expression each for each product.

Dimension: Year:

exp1: sum({<Product={'A'}>} Sale/SUM(LY_VALUE) - 1

exp2: sum({<Product={'B'}>} Sale/SUM(LY_VALUE) - 1

Exp3: sum(Sale)/SUM(LY_VALUE) - 1

Br,

KC

[swuehl]

Or enable the Total option on dimension limits tab in your original upper left chart:

[shiveshsingh]

May be this?

[adamgaox]

Hi Stefan,

Really nice way , learned a lot!

Though this way change the backend structure but it do have no impact on the other expressions in the front end.

Thank you very much.

Best Regards.

Jia-wen.

[adamgaox]

Thanks KC for your time. In the project senario, the product is dynamicly caculated.

[adamgaox]

This is also a good way.Thanks but the island table would be a better solution when the product is dynamicly calulated.