how to show total bar as first bar in bar chart in qlikview

[#1]

how to show total bar as first bar in bar chart in qlikview?

[sunny_talwar]

I know I am helping you with a method of doing this, but I believe that Kush's solution is much better than mine. You may need to understand what is going on, but it is more efficient. I urge you to reconsider using his method.

[#3]

This is also working. Perfect.

but from learning point of view, hows that giving 11 in earlier bar chart using "If(Only({1}F1) = 'Total', (Sum({1<F2 = p(F2)>}TOTAL F2) - 8), Sum(F2))" when I select A in F0.

(But when I select A in F0, I got 2,3,4 in F2 so If I add it will be 9 then subtract 8 will be 1 but in chart It is showing 11.)

This logic is giving some error in my actual qvw. Can I send you qvw  on your email If you dont mind.

[sunny_talwar]

Issue was with this part -> {1<F2 = p(F2)>}

F2 = p(F2) meant -> {<F2 = {'2', '3', '4'}>} which is not what we were looking for. It was sum all places that had 2, 3, 4 even in those places which were out of selection.

Ya, send me your actual qvw (if it is not huge)

[#5]

Sorry, I cannot find your email id here.

Can you give me please?

[sunny_talwar]

I sent you a private message with my email.