Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
l_denivelle
Creator
Creator

BarChart separate negative and positive values

Hi

I'm summing an amount of money which can be positive or negative and Qlikview naturally sum the positive and negative values together :

BarChart ko.PNG

I would like to separate the negative values from the positive values and then present them in a BarChart like this :

BarChart ok.png

Do you have any solution ?

Regards

1 Solution

Accepted Solutions
MarcoWedel

Hi,

another solution might be a calculated dimension and a single expression:

QlikCommunity_Thread_244796_Pic2.JPG

QlikCommunity_Thread_244796_Pic3.JPG

QlikCommunity_Thread_244796_Pic4.JPG

QlikCommunity_Thread_244796_Pic5.JPG

QlikCommunity_Thread_244796_Pic1.JPG

hope this helps

regards

Marco

View solution in original post

5 Replies
sunny_talwar

May be using two expressions

1) Positive

2) Negative

Capture.PNG

Anil_Babu_Samineni

It will show default, What the issue you are facing. Can you send the expression or Application to work on same

Capture.PNG

OR Use background color like below

If(Sum(Sales) >= 0, Green(), Red())

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Miguel_Angel_Baeyens

Sunny's suggestion will work. If you need those negative values for a different chart, you can always use the Fabs() function in the script and duplicate that field with absolute value for that chart and type of analysis, where you want to see the values separately, and the original, negative value where you can add or subtract in a different chart or expression.

MarcoWedel

Hi,

another solution might be a calculated dimension and a single expression:

QlikCommunity_Thread_244796_Pic2.JPG

QlikCommunity_Thread_244796_Pic3.JPG

QlikCommunity_Thread_244796_Pic4.JPG

QlikCommunity_Thread_244796_Pic5.JPG

QlikCommunity_Thread_244796_Pic1.JPG

hope this helps

regards

Marco

l_denivelle
Creator
Creator
Author

Hi

Thank you I managed to do it with your solution !