Solved: Re: how to show total bar as first bar in bar char... - Qlik Community

Report Inappropriate Content · ‎2015-12-11

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

sunny_talwar · ‎2015-12-11

See if this helps:

Script:

Table:

LOAD * INLINE [

F1, F2,F3

P1, 2,1

P2, 3,2

P3, 4,3

P4, 4,7

P1, 2,3

P2, 5,9

P3, 4,1

];

Concatenate (Table)

LOAD 'Total' as F1

AutoGenerate 1;

Expression1:

If(F1 = 'Total', (Sum(TOTAL F2) - 8), Sum(F2))

Expression2:

Sum(F3)

Sorting Expression:

=Match(F1, 'Total', 'P1', 'P2', 'P3', 'P4')

View solution in original post

Anonymous · ‎2015-12-11

Dont take any dimension,

Just take Expression only.

See the attachment

Report Inappropriate Content · ‎2015-12-11

but I need to take dimension.

I require Total as first and then remaining afterward

Anonymous · ‎2015-12-11

Then you would be getting dimension as well and you will be getting breakup of expression values with dimension as well..

What exactly you wanna?

Report Inappropriate Content · ‎2015-12-11

Hi,

I have bar chart with dimension limit >total ticked. Thats giving me Total bar in last. Can It be possible to put that total bar in start of bar chart as first bar?

Anonymous · ‎2015-12-11

could you post your QVW?

Anonymous · ‎2015-12-11

or try to sort the value...

sorting not working?

Report Inappropriate Content · ‎2015-12-11

Here it is

Report Inappropriate Content · ‎2015-12-11

Any luck?

Anonymous · ‎2015-12-11

doubt, if it is possible in case of Dimensality()