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

add extra bar in bar chart

Hi,

I need to add one more bar in start of chart. I have attcahed qvw and final image.

I have formulae for extra bar.

I have already tried total in dimension limit but thats not working

Help is appreciated.

1 Solution

Accepted Solutions
sunny_talwar

Try this expression:

If(Dimensionality() = 0, Sum(F2) - 8, Sum(F2))

Capture.PNG

View solution in original post

9 Replies
sunny_talwar

What is the logic behind that bar?

sunny_talwar

If you want to see a total bar, you can do this:

Capture.PNG

Not applicable
Author

I have already tried total, so not working.

l want to put 16 in that bar.

sunny_talwar

What does that 16 means my friend? How did you decide that number? Is there a logic behind 16 here? Is it always going to be 16 or will it be dynamic?

Anonymous
Not applicable
Author

What is the rational for wanting to show 16 ?

As in how would you want to calculate it ?

Not applicable
Author

logic is sum(F2)-8

Not applicable
Author

sum(F2)-8

sunny_talwar

Try this expression:

If(Dimensionality() = 0, Sum(F2) - 8, Sum(F2))

Capture.PNG

Not applicable
Author

Thanks a lot.

how to add Total  in start instead of at end?