Solved: Re: same way - Qlik Community

soniasweety · ‎2018-10-03

Hi all,

i have below image format as it is i want to build in qlikview is this possible? i want as it is shown in image

sunny_talwar · ‎2018-10-03

I guess this is not perfect (in a sense that it is not exactly what you may want), but this was to give you direction.... It gives the butterfly effect for what you wanted... rest of the things... like seeing negative numbers can be played around with... I am not sure what all things are important for you (like mouse over etc)... so I cannot make this perfect unless you tell me what all things are important.

Does that make sense?

View solution in original post

sunny_talwar · ‎2018-10-03

May be a butterfly chart

Butterfly chart example

sunny_talwar · ‎2018-10-03

Actually check this out

How to create Tornado Or Butterfly Chart in Qlikview - YouTube

sunny_talwar · ‎2018-10-03

Can something like this work?

soniasweety · ‎2018-10-03

Hi want to incrporate the format in the expression

how can i do that?

in first expression i tried but its not working

sunny_talwar · ‎2018-10-03

Format?

soniasweety · ‎2018-10-03

yes sunny number format.

i want to show billion and million and thousands

so i hve created inline and variable and using that variable in expression. so now i want to use the same here

soniasweety · ‎2018-10-03

see in sheet1 my actual chart is this

stalwar1

sunny_talwar · ‎2018-10-03

This?

soniasweety · ‎2018-10-03

smal doubt..

why second expression? is this will effect the result?