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

% and units in bar graph

Hello

I have an expression that is very complex but in summary is sum(something) / sum( total something) and i'm seeing it in %

I'd like to see that in the same way but the total in units

The graph number 1 is what i'm seeing and the 2 is that i'd like to see

Is that possible?

Thanks,

Regards

19 Replies
sunny_talwar

May be use this as your expression:

Dual(Sum(something), Sum(something)/Sum(TOTAL something))

Sum(something) - for displaying

Sum(something)/Sum(TOTAL something) - for plotting

Not applicable
Author

Do you have some example to show this? i used the function dual in the past but i'm not sure to how use it now

Thanks

stabben23
Partner - Master
Partner - Master

Hi,

make a second Expression, tick only "Values On Datapoint", go to presentation tab, untick "Vertical" and "Plot values inside segment", should work.

sunny_talwar

You can see here:

How to use- Dual()

sunny_talwar

Make sure you select 'Expression Default' on the numbers tab for the formatting of the numbers. and then use Num() function to display it the way you would want to see the number

Not applicable
Author

But that will work in my stacked graph?...

Not applicable
Author

I have to make two expressions?

sunny_talwar

Difficult to say without having a look at a sample

Not applicable
Author

the image isn't enough? i'll make an example but i need a few minutes