Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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