topic Requirement on Bar chart in QlikView

Requirement on Bar chart

chinnu123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have an issue with Stacked bar chart representation. I need to represent a Bar to 100% what ever the value it is if it is 20 also the bar must be shown to 100% but the value point of that bar is 20 if it is 50 also the bar should be shown to 100% only. The value points of that bar is 50. hope understand..

Can any one help on this..

Thanks in Advance

Re: Requirement on Bar chart

sunny_talwar — Fri, 15 Jul 2016 23:01:25 GMT

Lets say you have two dimensions (Dimension1 and Dimension2) and your expression is Sum(Sales)....

Try this:

Sum(Sales)/Sum(TOTAL <Dimension1> Sales)

Re: Requirement on Bar chart

chinnu123 — Fri, 15 Jul 2016 23:10:07 GMT

Hi sunny Thanks for replay..

Below is my Expression and my dimension is month .could you please complete this.

Count({<[Web Application]={'App '}>} [Web Application])/100

Re: Requirement on Bar chart

sunny_talwar — Fri, 15 Jul 2016 23:18:20 GMT

You have only one dimension? and you wish to get 100% for each bar? I am confused, what is the use of that?

Re: Requirement on Bar chart

chinnu123 — Fri, 15 Jul 2016 23:28:28 GMT

Though we have one dimension but we have 5 expressions.

For example I have A, B,C,D,E are the 5 expressions and I have a selection object Country In that I have USA, CANADA,RUSSIA etc

If I select CANADA i have a values for A&B so the bar should show for only A &B but it must be shown to 100%

Is this helpful?

Re: Requirement on Bar chart

sunny_talwar — Fri, 15 Jul 2016 23:35:35 GMT

How about this:

divide each expression by this:

RangeSum(A, B, C, D, E)

Where A will be replaced by your 1st expression and so on...

Re: Requirement on Bar chart

chinnu123 — Fri, 15 Jul 2016 23:56:47 GMT

Unfortunately its not working

Re: Requirement on Bar chart

sunny_talwar — Sat, 16 Jul 2016 02:35:38 GMT

Can you share a sample of data with expected output to help you better?