topic Re: Butterfly chart example in QlikView

Butterfly chart example

mrybalko — Tue, 06 Aug 2013 11:10:23 GMT

Hello.

Here is my butterfly chart solution. Max losses and profit values are highlighted. Values on data points are shown when less then 15 dates are selected (see vShownNum variable)

I used 2 bar charts and number format hints for losses bar.

Re: Butterfly chart example

Mon, 14 Jul 2014 07:03:29 GMT

Hi Maxim,

Example is fine , plz can you explain how it was working ?

Regards,

Helen

Re: Butterfly chart example

Mon, 04 Aug 2014 16:14:17 GMT

Hi Maxim,

This is great.

I am also trying to create Butterfly chart, but not able to do it.

Please see the attached Qvd and suggest what i am doing wrong.

Regards,

manish virmani

Re: Butterfly chart example

Anil_Babu_Samineni — Tue, 07 Jun 2016 15:10:39 GMT

Nice Explanation..

So, i have one small question.

If i have two tables with two date fields.

Is that possible to create Butterfly same as your qvw...

If possible, i will share my qvw so that i need big help from you

- Anil

Re: Butterfly chart example

kmstephenson — Fri, 19 Aug 2016 13:32:38 GMT

This is awesome!! How did you display Losses as a positive number on the chart data values and pop ups?

Re: Butterfly chart example

mrybalko — Fri, 19 Aug 2016 13:40:00 GMT

Pay attention to Format Pattern. It is used the same pattern for negative and positive numbers.

# ##0; # ##0

Re: Butterfly chart example

kmstephenson — Fri, 19 Aug 2016 13:47:03 GMT

Is it possible to do with a chart where I show percents? I used the following format:

But it doesn't work to use the same format for the left side of the chart because it shows the #s as negative, which I don't want:

Re: Butterfly chart example

kmstephenson — Fri, 19 Aug 2016 13:49:49 GMT

Ahhhh, just noticed all I needed was the semicolon and to repeat it! Thank you!!

Re: Butterfly chart example

Anil_Babu_Samineni — Fri, 19 Aug 2016 15:30:29 GMT

I am not sure, whether I understand your problem.

Perhaps this, (#,##0); (#,##0)