topic Re: Percentage Bar Graph in QlikView

Percentage Bar Graph

Thu, 09 Jun 2016 16:00:22 GMT

Hi All,

Have an urgent question about displaying a percent bar graph. I cant get the right expression. I've attached a sample excel with the desired result.

Many thanks.

Sarosh

Re: Percentage Bar Graph

sunny_talwar — Thu, 09 Jun 2016 16:06:27 GMT

You have not provided the expression you are using and no mention of the expression is made as well. Look here to know how you can quickly get answers for your questions -> QlikCommunity Tip: How to get answers to your post?‌

Re: Percentage Bar Graph

Thu, 09 Jun 2016 16:11:47 GMT

Thanks Sunny.

What I want to achieve is to display the POS percentages in a bar graph. The percentages are already calculated so that's where I'm lost. I started with sum(POS) as an expression and columns Transition and All as dimensions. But its not working out.

Sorry for the rushed message.

Re: Percentage Bar Graph

sunny_talwar — Thu, 09 Jun 2016 16:18:23 GMT

How would you calculate these percentages outside QlikView? I have no idea how you reaching these numbers to be able to suggest you anything

Re: Percentage Bar Graph

Thu, 09 Jun 2016 16:35:54 GMT

In this scenario I dont want to use Qlikview for calculation rather for a dynamic visualization.

Just figured it out, I didnt need to put an expression I simply put, =POS(name of column).

Many thanks!