Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I change Y axis to always maximum 100% view

Hi Everyone,

Can somebody help me I want to change the Y-Axis to 100% max instead of the actual value.

Please see attached file. I would like to look like the YAxis 100% View a.jpg.

Thanks.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.

Dimensions : Dimension1, Dimension2

Expression: =Sum(MeasureName)/ Sum(TOTAL <Dimension1> MeasureName)

and in Number tab select Integer and Show in Percent(%) options.

Regards,

Jagan.

View solution in original post

8 Replies
Not applicable
Author

YAxisb.jpgYAxixa_.jpg

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.

Dimensions : Dimension1, Dimension2

Expression: =Sum(MeasureName)/ Sum(TOTAL <Dimension1> MeasureName)

and in Number tab select Integer and Show in Percent(%) options.

Regards,

Jagan.

Not applicable
Author

Hi Thank you it works like a gem.

One more thing can I change the value on tool tip instead of 33% the actual value 20,909 for this example?

Yaxisc.jpg

jagan
Luminary Alumni
Luminary Alumni

Hi,

Add another expression

Expression: =Sum(MeasureName) and select Text as Popup in

Chart Properties -> Expression tab.


Regards,

jagan.

Not applicable
Author

Thank you so much.

Not applicable
Author

Hello Guys,

I have a similar issue, but not the same. The data I have is arranged in a different way, and I can't figure out a way to make this solution work for my situation.

So my data looks like so:

MonthABCDE
Oct-1565311106
Nov-151250110
Dec-15195298
Jan-16103387
Feb-16174467
Mar-16131938

I would like to use the Y axis to display the stacked values of columns A to E, but I want to all of those to fill it to 100%.

It should look something like this (I have this graph in Excel, but I can't figure out how to build it in QV)

Graph.png

Not applicable
Author

I actually figured it out myself, after 2 days of trying out different things

Here is the formula I used for each of the Expressions:

For A:

sum(A)/(sum(TOTAL<Month> A)

+ Sum(TOTAL <Month> B)

+ Sum(TOTAL <Month> C)

+ Sum(TOTAL <Month> D)

+ Sum(TOTAL <Month> E))

For B:

sum(B)/(sum(TOTAL<Month> A)

+ Sum(TOTAL <Month> B)

+ Sum(TOTAL <Month> C)

+ Sum(TOTAL <Month> D)

+ Sum(TOTAL <Month> E))

And so on ...

I also set each of the Expressions to Integer and Show in percentage in the Number tab.
Now, the only thing left to figure out is how to show the actual numbers in the bar chart, instead of percentages.

I'd appreciate it, if you can help me with this one.

jagan
Luminary Alumni
Luminary Alumni

You should not use like this you have to use crosstable() to transform the data so that you can easily achieve this.  I am not sure of displaying numbers in Bars when you are calculating percentages.

Regards,

Jagan.