topic Re: how to show total bar as first bar in bar chart in qlikview in QlikView

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

Fri, 11 Dec 2015 09:55:23 GMT

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

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

Anonymous — Fri, 11 Dec 2015 09:57:51 GMT

Dont take any dimension,

Just take Expression only.

See the attachment

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

Fri, 11 Dec 2015 10:00:36 GMT

but I need to take dimension.

I require Total as first and then remaining afterward

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

Anonymous — Fri, 11 Dec 2015 10:02:34 GMT

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?

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

Fri, 11 Dec 2015 10:04:50 GMT

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?

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

Anonymous — Fri, 11 Dec 2015 10:08:48 GMT

could you post your QVW?

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

Anonymous — Fri, 11 Dec 2015 10:09:26 GMT

or try to sort the value...

sorting not working?

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

Fri, 11 Dec 2015 10:17:16 GMT

Here it is

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

Fri, 11 Dec 2015 10:27:44 GMT

Any luck?

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

Anonymous — Fri, 11 Dec 2015 10:31:15 GMT

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

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

sunny_talwar — Fri, 11 Dec 2015 10:43:45 GMT

What is your expected Total now?

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

Fri, 11 Dec 2015 10:45:49 GMT

attached same qvw we discussed. how to show Total as first bar

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

sunny_talwar — Fri, 11 Dec 2015 10:48:14 GMT

Oh got it

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

sunny_talwar — Fri, 11 Dec 2015 10:52:31 GMT

I think you will need to do something in the script for the that. Does working in script an option? Look at this, it also is on similar lines -> How to show the "total" bar at the left most of the bar chart

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

sunny_talwar — Fri, 11 Dec 2015 11:33:07 GMT

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')

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

Fri, 11 Dec 2015 11:47:53 GMT

Hi,

Its absolutely right for current scenarion. but If one more column is added to inline load. In that case If I select any value from that column. Total will disappear as It is not having any value related in new column.

Added qvw.

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

Kushal_Chawda — Fri, 11 Dec 2015 11:56:24 GMT

Further simplified

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

];

LOAD * Inline [

Dim

2 ];

Create the chart

Dimension:

=Pick(Dim,'Total',F1)

Expression1:

=Pick(Dim,

Sum(total F2) - 8,

Sum(F2))

Expression2:

=Pick(Dim,

Sum(F3))

In Sort Tab Expression

=Pick(Dim)

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

sunny_talwar — Fri, 11 Dec 2015 11:59:12 GMT

See if this helps:

If(F1 = 'Total', (Sum({1<F2 = $::F2>}TOTAL F2) - 8), Sum(F2))

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

Fri, 11 Dec 2015 12:37:59 GMT

If you select then, total is not showing

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

sunny_talwar — Fri, 11 Dec 2015 12:43:08 GMT

What selection are you making?