topic Re: qlikview-barchart in QlikView

qlikview-barchart

ryanwangf — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: qlikview-barchart

Anil_Babu_Samineni — Tue, 12 Jul 2016 08:33:44 GMT

Hello,

If your dimension is coming from One table. Then it's easy. (PFA for ref)

If your dimension coming from two tables then it takes bit risk. That time we need to create two charts and then merge those two graphs.

Re: qlikview-barchart

Tue, 12 Jul 2016 08:37:23 GMT

Use horizontal bar charts and add expressions might achieve this, but i have never tried to make a symmetric before.

Re: qlikview-barchart

ryanwangf — Tue, 12 Jul 2016 09:05:46 GMT

Yes,Anil,the dimension is from one table.I wanna create two charts then merge those two grahs，but i don't know how to create the left chart,because the axes is on the right.so, do you have any idea? Thanks

Re: qlikview-barchart

ryanwangf — Tue, 12 Jul 2016 09:13:39 GMT

Thanks, I know i can't finish it with one chart,so i wannt create two charts and then merge them,and the right one is easy to create, but i don't know how to create the left one,you know the axes is on the right.Do you have any idea about the left one chart. Thanks!

Re: qlikview-barchart

Anil_Babu_Samineni — Tue, 12 Jul 2016 10:32:31 GMT

Can you please share me your sample App with Dimensions and Expressions

Send me raw data with the Used dimensions and Calc Dimensions

Re: qlikview-barchart

ryanwangf — Tue, 12 Jul 2016 13:31:03 GMT

Hello Anil:

I just made a demo, and i wanna finish the printscreen result,but i don't know how to do it.

Just check the attachment.

Thanks for your help.

Best Regards

王传峰 | Ryan Wang

M. 13718050927

ryan.wang@analyticservice.net

Re: qlikview-barchart

Anil_Babu_Samineni — Tue, 12 Jul 2016 14:08:13 GMT

Like this,

Re: qlikview-barchart

ryanwangf — Tue, 12 Jul 2016 14:16:35 GMT

Yes, Anil,that's great.Can you tell me how can I create chart like this

Re: qlikview-barchart

Anil_Babu_Samineni — Tue, 12 Jul 2016 14:41:33 GMT

Try This..

You have only one chart, But why this file showing 27MB.

Anyway, Check these options, Please?

- ANIL

Re: qlikview-barchart

vishsaggi — Tue, 12 Jul 2016 14:47:15 GMT

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.

Re: qlikview-barchart

Anil_Babu_Samineni — Tue, 12 Jul 2016 14:54:42 GMT

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

Re: qlikview-barchart

Anonymous — Tue, 12 Jul 2016 15:03:01 GMT

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

Re: qlikview-barchart

ryanwangf — Tue, 12 Jul 2016 15:10:50 GMT

thanks,that's a good idea

Re: qlikview-barchart

ryanwangf — Tue, 12 Jul 2016 15:12:04 GMT

Thanks very much.I have finished by your method

Re: qlikview-barchart

vishsaggi — Tue, 12 Jul 2016 15:12:11 GMT

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,

Re: qlikview-barchart

ryanwangf — Tue, 12 Jul 2016 15:13:42 GMT

Yes,Anil and Vishsaggi are correct

Re: qlikview-barchart

vishsaggi — Tue, 12 Jul 2016 15:31:41 GMT

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,

Re: qlikview-barchart

ryanwangf — Wed, 13 Jul 2016 01:10:29 GMT

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