qlikview-barchart

[ryanwangf]

Hello,guys:

I wanna do this kind of bar chart with qlikview, maybe i have to do two bar charts, but how can i finish the left one,the axes is on the right,so do you guys have any ideas?

BTY, there are two KPIs and a dimension.

Thanks

[vishsaggi]

Add Minus to both the expressions in the expression tab like

- Count(colName)

Then uncheck show legend in the dimensions tab for the dimension used.

Thanks,
V.

[Anil_Babu_Samineni · Accepted solution]

vishsaggi

Continuation should be. As i understand, User want to see the values in +Ve values

1) so you need to arrange the format from Number tab of each expression is Integer --->            #,##0; #,##0

2) Same as Sales Person

3) Sort Tab -- Y-Value --> Ascending

4) From Axis Tab - Each expression width should be o Pixel

Good Luck

[Anonymous]

Not sure if you are looking this way of display of charts. Please let me know if that helps

[ryanwangf]

thanks,that's a good idea

[ryanwangf]

Thanks very much.I have finished by your method

[vishsaggi]

Thanks Anil for that. Yes, just change these things accordingly.

The Number format doesn't change until explicitly changed. But good to cross check the tabs.

Ryan, please let us know if this suffice your requirement.

Thanks,

V.

[ryanwangf]

Yes,Anil and Vishsaggi are correct

[vishsaggi]

One more thing Ryan, once you have this chart, when you hover over the bar chart on left, the pop up shows as -ve value. So to overwrite this follow below tips:

On the left hand chart,

1. Presentation Tab: uncheck pop up labels.

2. Expression Tab : Expr1: Add  = 'Sales Person =' & COUNT ([Trade Revenue]) -> Uncheck Bar -> And check Text as                                         popup

                             Expr2: Add  = 'Amount = ' & Sum (IF([Commission %]=0,[Trade Amount]))/100000 -> Uncheck Bar

                                        -> And check text as popup

Let me know if this helps. It might need little tweak around though.

Let us know how it goes.

Thanks,

V.

[ryanwangf]

I have finished this chart.Just like you guys said.Thanks so much.