Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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.

Tags (1)
1 Solution

Accepted Solutions

Re: add extra bar in bar chart

Try this expression:

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

Capture.PNG

9 Replies

Re: add extra bar in bar chart

What is the logic behind that bar?

Re: add extra bar in bar chart

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

Capture.PNG

Not applicable

Re: add extra bar in bar chart

I have already tried total, so not working.

l want to put 16 in that bar.

Re: add extra bar in bar chart

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

What is the rational for wanting to show 16 ?

As in how would you want to calculate it ?

Not applicable

Re: add extra bar in bar chart

logic is sum(F2)-8

Not applicable

Re: add extra bar in bar chart

sum(F2)-8

Re: add extra bar in bar chart

Try this expression:

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

Capture.PNG

Not applicable

Re: add extra bar in bar chart

Thanks a lot.

how to add Total  in start instead of at end?