topic Re: Percentage bar in combochart in QlikView

Percentage bar in combochart

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

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

Please help to check attached qvw.

Thanks in advance.

Re: Percentage bar in combochart

qlikviewwizard — Wed, 26 Aug 2015 11:30:44 GMT

Sasidhar Parupudi‌

Mayil Vahanan Ramasamy

jagan mohan

Kush141087‌

swuehl

Please advise.

Re: Percentage bar in combochart

qlikmsg4u — Wed, 26 Aug 2015 11:34:06 GMT

Like this?

Re: Percentage bar in combochart

qlikviewwizard — Wed, 26 Aug 2015 11:37:08 GMT

Hi QLIKmsg4u

Absolutely. Please give the steps how to do this.

Re: Percentage bar in combochart

mohammadkhatimi — Wed, 26 Aug 2015 11:38:10 GMT

In attached qvw, the symbols expressions i.e 3rd and 4th exopression ia at right(top) position in axes tab..

therefore its showing two axes, % axis is for 3rd and 4th expression.

And also check relative for 3rd and 4th expression

Regards,

Mohammad

Re: Percentage bar in combochart

qlikmsg4u — Wed, 26 Aug 2015 11:39:11 GMT

Check relative for expressions 3 and 4 in expressions tab

Re: Percentage bar in combochart

Kushal_Chawda — Wed, 26 Aug 2015 11:52:05 GMT

You can go with the suggestion given by K N

Re: Percentage bar in combochart

qlikviewwizard — Wed, 26 Aug 2015 13:49:22 GMT

Hi All,

Why I am not able to do with the same options?

Re: Percentage bar in combochart

kkkumar82 — Wed, 26 Aug 2015 14:00:01 GMT

Hi,

You just missed out checking the 3 and 4 th expressions to relative in the expressions tab.

Thanks

Kiran Kumar

Re: Percentage bar in combochart

qlikviewwizard — Wed, 26 Aug 2015 14:10:24 GMT

Hi All,

Thank you for answers.

Re: Percentage bar in combochart

jagan — Wed, 26 Aug 2015 15:10:00 GMT

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.

Re: Percentage bar in combochart

jagan — Wed, 26 Aug 2015 15:10:45 GMT

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

Regards,

Jagan.

Re: Percentage bar in combochart

qlikviewwizard — Sat, 29 Aug 2015 16:12:16 GMT

Thank you Jagan