topic Re: add extra bar in bar chart in QlikView

add extra bar in bar chart

Thu, 10 Dec 2015 19:14:12 GMT

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.

Re: add extra bar in bar chart

sunny_talwar — Thu, 10 Dec 2015 19:16:31 GMT

What is the logic behind that bar?

Re: add extra bar in bar chart

sunny_talwar — Thu, 10 Dec 2015 19:18:37 GMT

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

Re: add extra bar in bar chart

Thu, 10 Dec 2015 19:21:22 GMT

I have already tried total, so not working.

l want to put 16 in that bar.

Re: add extra bar in bar chart

sunny_talwar — Thu, 10 Dec 2015 19:22:39 GMT

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?

Re: add extra bar in bar chart

Anonymous — Thu, 10 Dec 2015 19:23:04 GMT

What is the rational for wanting to show 16 ?

As in how would you want to calculate it ?

Re: add extra bar in bar chart

Thu, 10 Dec 2015 19:29:02 GMT

logic is sum(F2)-8

Re: add extra bar in bar chart

Thu, 10 Dec 2015 19:31:35 GMT

sum(F2)-8

Re: add extra bar in bar chart

sunny_talwar — Thu, 10 Dec 2015 19:35:57 GMT

Try this expression:

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

Re: add extra bar in bar chart

Thu, 10 Dec 2015 19:56:00 GMT

Thanks a lot.

how to add Total in start instead of at end?