Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Help required on Butterfly chart

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#581967http://http://community.qlik.com/message/581967#581967

Please help

Regards,

Manish Virmani

1 Solution

Accepted Solutions
tobias_klett
Contributor II

Re: Help required on Butterfly chart

Hi Manish,

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

Regards

Tobias

View solution in original post

8 Replies
tobias_klett
Contributor II

Re: Help required on Butterfly chart

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

Not applicable

Re: Re: Help required on Butterfly chart

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

tobias_klett
Contributor II

Re: Help required on Butterfly chart

Hi Manish,

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

Regards

Tobias

View solution in original post

Not applicable

Re: Help required on Butterfly chart

Thank you so much Tobias!!!

It worked for me.

Regards,

Manish Virmani

Not applicable

Re: Help required on Butterfly chart

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

tobias_klett
Contributor II

Re: Help required on Butterfly chart

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

Not applicable

Re: Help required on Butterfly chart

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,

MV

Highlighted
Not applicable

Re: Help required on Butterfly chart

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

                                                     for negative

and scale-set step make number to positive