topic Re: Butterfly or Tornado Chart in App Development

Butterfly or Tornado Chart

Thu, 17 Dec 2015 20:05:08 GMT

Hey guys,

I am looking for a solution how to design butterfly or tornado chart.

I have 1 dimension (NameField) and 2 expressions (# and %)

Thanks for the help.

Re: Butterfly or Tornado Chart

robert_mika — Thu, 17 Dec 2015 20:29:00 GMT

Look here:

Butterfly chart example

Feeling Qlikngry?

How To /Missing Manual(25 articles)

Re: Butterfly or Tornado Chart

reddy-s — Thu, 17 Dec 2015 20:35:26 GMT

Hi Branislav,

You can follow the procedure which Robert mentioned. Works the same in QlikSense as well.

Re: Butterfly or Tornado Chart

Fri, 18 Dec 2015 14:07:30 GMT

Sangram/Robert:

I am still kind of confused. I am not quite sure how Robert got to the final chart? Any information is greatly appreciated.

Re: Butterfly or Tornado Chart

reddy-s — Sat, 19 Dec 2015 21:01:02 GMT

Hi Branislav,

Is it possible to post some sample data so that I can help you achieve it?

Thanks,

Sangram Reddy.

Re: Butterfly or Tornado Chart

Mon, 21 Dec 2015 14:42:08 GMT

Hi Sangram:

Here is an example of the data that I am trying to chart into Butterfly chart in Qlik Sense. Thanks for the help

Re: Butterfly or Tornado Chart

reddy-s — Mon, 21 Dec 2015 19:03:41 GMT

Hi Branislav,

Here is an example on how to achieve this.

Check this out:

you can achieve this in two different ways as in images above. Check the QVF file for more info(attached).

Cheers,

Sangram Reddy.

Re: Butterfly or Tornado Chart

Mon, 21 Dec 2015 23:54:32 GMT

Sangram:

Thanks for the solution. It looks great. Only thing that I see is that you had to use negative values for %. Which I could live with. You mentioned QVF file, but I do not see it attached.

Thanks,Branislav

Re: Butterfly or Tornado Chart

reddy-s — Tue, 22 Dec 2015 09:12:54 GMT

Hi branislav,

Try opening the thread in a separate tab and you will be able to find it there.

Cheers,

Sangram Reddy.

Re: Butterfly or Tornado Chart

Tue, 22 Dec 2015 17:13:16 GMT

Sangram:

I found the attachment. For some reason, my browser wouldn't show it at first.

thanks again for your help.

Branislav

Re: Butterfly or Tornado Chart

reddy-s — Tue, 22 Dec 2015 17:25:28 GMT

Always welcome.

Cheers,

Sangram

Re: Butterfly or Tornado Chart

Wed, 23 Mar 2016 02:05:39 GMT

Sangram:

I found a solution to trick the negative values on the left of the two charts you created.

What you have to do is to change the format to Money and remove $ or other sign and negative sign for negative numbers, I was able to do on another sample % sign on the bottom left chart as well. For some reason I can't figure out how to format the value to show 80%

BEFORE:

AFTER:

Re: Butterfly or Tornado Chart

reddy-s — Fri, 25 Mar 2016 13:44:40 GMT

Hi Branislav,

Can you post a sample QVF please? Happy to help.

Thanks,

Sangram.

Re: Butterfly or Tornado Chart

Anil_Babu_Samineni — Tue, 07 Jun 2016 15:18:54 GMT

Sangram,

How do we open this extension..

Can you please let me know.

Re: Butterfly or Tornado Chart

reddy-s — Thu, 09 Jun 2016 10:15:37 GMT

That's Great! Thx for sharing!

Re: Butterfly or Tornado Chart

reddy-s — Thu, 09 Jun 2016 10:16:21 GMT

Hi Anil,

This is not an extension. So if you copy the QVF to your apps folder you will be able to view it in your hub.

Thanks,

Sangram.

Re: Butterfly or Tornado Chart

Anil_Babu_Samineni — Thu, 09 Jun 2016 10:17:55 GMT

Can you please explain me more.

Re: Butterfly or Tornado Chart

reddy-s — Thu, 09 Jun 2016 10:21:42 GMT

Hi Anil,

Just download the qvf , copy the downloaded qvf to your apps folder in the below location :

C:\Users\<User>\Documents\Qlik\Sense\Apps

Then open your desktop version or server hub. You will be able to see the app there.

Thanks,

Sangram.

Re: Butterfly or Tornado Chart

Anil_Babu_Samineni — Thu, 09 Jun 2016 10:24:02 GMT

Nice Explanation, Thanks

Re: Butterfly or Tornado Chart

reddy-s — Thu, 09 Jun 2016 10:28:07 GMT

Always welcome!