Percentage bar in combochart

[qlikviewwizard]

Hi All,

How to show percentage bar in combo chart as shown in screen?

Please help to check attached qvw.

Thanks in advance.

[jagan]

Hi,

You can select Relative option for the expressions in the Expression tab.

Or another way is your expression should be like this

sum( {<Year = {"$(=$(CurrYear($1)))"} >} Sales)/sum( {<Year = {"$(=$(CurrYear($1)))"} >} TOTAL Sales)

Hope this helps you.

Regards,

jagan.

[jagan]

TOTAL in expression will ignore the dimension and it will give overall sales.

Regards,

Jagan.

[qlikviewwizard]

Thank you Jagan