topic Re: same way in QlikView

same way

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

franky_h79

Jyothish KC

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

Re: same way

sunny_talwar — Wed, 03 Oct 2018 11:16:57 GMT

May be a butterfly chart

Butterfly chart example

Re: same way

sunny_talwar — Wed, 03 Oct 2018 11:20:36 GMT

Actually check this out

How to create Tornado Or Butterfly Chart in Qlikview - YouTube

Re: same way

sunny_talwar — Wed, 03 Oct 2018 11:27:51 GMT

Can something like this work?

Re: same way

soniasweety — Wed, 03 Oct 2018 11:46:57 GMT

Hi want to incrporate the format in the expression

how can i do that?

in first expression i tried but its not working

Re: same way

sunny_talwar — Wed, 03 Oct 2018 11:48:34 GMT

Format?

Re: same way

soniasweety — Wed, 03 Oct 2018 12:04:09 GMT

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

Re: same way

soniasweety — Wed, 03 Oct 2018 12:07:17 GMT

see in sheet1 my actual chart is this

stalwar1

Re: same way

sunny_talwar — Wed, 03 Oct 2018 12:18:40 GMT

This?

Re: same way

soniasweety — Wed, 03 Oct 2018 12:26:28 GMT

smal doubt..

why second expression? is this will effect the result?

Re: same way

sunny_talwar — Wed, 03 Oct 2018 12:27:55 GMT

Used to create the butterfly effect

Re: same way

soniasweety — Wed, 03 Oct 2018 12:30:07 GMT

bcz in my data there is no negative values but still it sis showing in negative bar

Re: same way

sunny_talwar — Wed, 03 Oct 2018 12:36:07 GMT

That is because I have multiplied the second expression with -1.... I am not sure I understand your concern... what exactly is the issue? The axis showing -1 numbers?

Re: same way

soniasweety — Wed, 03 Oct 2018 12:41:16 GMT

yes when i mouse over on negative bar it is showing negative values right? but for that i dont have negative data in my db.

if user mouseover on that then it will be negative numbers shown right?

Re: same way

sunny_talwar — Wed, 03 Oct 2018 13:05:52 GMT

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?

Re: same way

soniasweety — Wed, 03 Oct 2018 13:07:57 GMT

yes understood sunny... anyway we are dispalying the numbers on the bar so no need of mouseover here

Re: same way

sunny_talwar — Wed, 03 Oct 2018 13:11:51 GMT

Hahahaha but remember I am not saying that it can't be fixed... but there are n number of things you would want differently, but I can't work on them unless I know what they are.

Best,

Sunny

Re: same way

soniasweety — Wed, 03 Oct 2018 13:42:19 GMT

hmmm ... let me come back if anything is there thanks

Re: same way

soniasweety — Thu, 11 Oct 2018 11:53:21 GMT

Hi sunny in this i need small help

i want to show the data points out side ...bcz if i put inside some of the bar values are not visible so how can i do this?

Sunny Talwar

Re: same way

sunny_talwar — Thu, 11 Oct 2018 12:01:00 GMT

Shows up on both the sides... not sure if this is something which is acceptable or not... but can't think of another way to do this