Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

MVP & Luminary
MVP & Luminary

Re: Percentage bar in combochart

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.

MVP & Luminary
MVP & Luminary

Re: Percentage bar in combochart

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

Regards,

Jagan.

Arjunarao
Honored Contributor II

Re: Percentage bar in combochart

Thank you Jagan