Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

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

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

Tags (1)
1 Solution

Accepted Solutions

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

See if this helps:

Capture.PNG

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

34 Replies
balrajahlawat
Esteemed Contributor

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

Dont take any dimension,


Just take Expression only.


See the attachment

Not applicable

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

but I need to take dimension.

I require Total as first and then remaining afterward

balrajahlawat
Esteemed Contributor

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

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?

Not applicable

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

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?

balrajahlawat
Esteemed Contributor

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

could you post your QVW?

balrajahlawat
Esteemed Contributor

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

or try to sort the value...

sorting not working?

Not applicable

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

Here it is

Not applicable

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


Any luck?

balrajahlawat
Esteemed Contributor

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

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