topic Re: Help required on Butterfly chart in QlikView

Help required on Butterfly chart

Mon, 04 Aug 2014 18:19:58 GMT

Hi All,

I am trying to create a butterfly chart, but not able to create it. Please see the attached file and suggest the solution. I have also gone through the below link but not able to get it.

http://community.qlik.com/message/581967#581967 http://http://community.qlik.com/message/581967#581967

Please help

Regards,

Manish Virmani

Re: Help required on Butterfly chart

tobias_klett — Mon, 04 Aug 2014 18:43:05 GMT

Hi Manish,

let me see what I did to your file:

On Tab Expression

- I put a "-" in front of your expression on the left chart.
- on left top corner overview I opened the expression ("+") and put background red().
- As Option without showing the minus symbol in the chart a added a disabled dual-expression

On Tab Dimension

- I put a blank as label to make it use the same space without label on the left chart

- I deleted the mark for show labels

On Tab Axis

- I marked Hide Axis for left and right chart

Hope this helps

Tobias

Re: Re: Help required on Butterfly chart

Tue, 05 Aug 2014 18:17:23 GMT

Hi Tobias,

It seems to be very helpful, but why the numbers on the left char coming negative, it should be positive.

Please see the attached data. And X Axis value is not coming.

Thank you for taking your time.

In both the charts value either should be zero or greater than zero but not negative.

Please suggest!

Thanks

Manish Virmani

Re: Help required on Butterfly chart

tobias_klett — Wed, 06 Aug 2014 18:15:54 GMT

Hi Manish,

disable the expression in the left chart and enable the one i disabled.

Regards

Tobias

Re: Help required on Butterfly chart

Wed, 06 Aug 2014 18:56:55 GMT

Thank you so much Tobias!!!

It worked for me.

Regards,

Manish Virmani

Re: Help required on Butterfly chart

Wed, 06 Aug 2014 19:01:13 GMT

Hi Tobias,

Is there any way around it so that we can show the Axis value also at the bottom of both the charts.

Because in the example attached in my first conversation it has the bottom Axis value.

Regards,

Manish Virmani

Re: Help required on Butterfly chart

tobias_klett — Thu, 07 Aug 2014 06:28:18 GMT

Hi Manish,

you can go to Axes-Tab mark your expression an unclick hide axis for both charts. But it will show negative figures an the left charts which were needed to make it go from right to left. 😞

Regards
Tobias

Re: Help required on Butterfly chart

Mon, 11 Aug 2014 05:54:43 GMT

Hi Tobias,

I have seen it in some example where on the left chart there were no negative value, i am trying to find out the way, if i come with the solution i will post here.

Thank you so much for your time.

Regards,

Re: Help required on Butterfly chart

Mon, 11 Aug 2014 06:55:12 GMT

Use number format - Integer - #,##0; #,##0

for negative

and scale-set step make number to positive