Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
Highlighted
Not applicable

How to get positive value

Hi, how to get the positive value on the right side of the butterfly chart,if any help thanks in advance.

untitled13.bmp

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: How to get positive value

Hi,

I got it we should use the Dual function

Thanks for ur time.

View solution in original post

7 Replies
Highlighted
Not applicable

Re: How to get positive value

Hi ,

     Just multiply with -1(Expression * -1)

   we can get positive values instead of negative

Thanks

Manju

Highlighted
arulsettu
Honored Contributor III

Re: How to get positive value

if you want to convert the negative values to positive do like this

fabs(your expression)

Highlighted
sunilkumarqv
Valued Contributor II

Re: How to get positive value

change your Expression to positive using fabs function

fabs(Sum(value))

Highlighted
Not applicable

Re: How to get positive value

it is not working

Highlighted
Not applicable

Re: How to get positive value

Hi,

i want that chart in the negative axis only but the datapoints should be positive.

Highlighted
Not applicable

Re: How to get positive value

Hi,

I got it we should use the Dual function

Thanks for ur time.

View solution in original post

Highlighted
Partner
Partner

Re: How to get positive value

Go to properties and set the Min Axes to 0

Axis.png