Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
spikenaylor1
Creator
Creator

Bar Chart above and below axis

I have created the chart I want but need to know how to hide the - for the below axis

BarChart.JPG

The Deviations need to show as not negative, cant figure out how to hide the -

any help please kind people

7 Replies
Anil_Babu_Samineni

What was the expressions you used for Deviations and Risks. And, As i assume you don't want to take -Ve Values. Please confirm those

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
spikenaylor1
Creator
Creator
Author

the expression is

=sum(Deviations)*-1

I may have figured out a sort of solution.

Expressions: Values on Data Points (Selected)

Presentation: Plot Values inside Segments (Selected)

Axes: Hide Axis (Selected)

BarChart1.JPG

Anil_Babu_Samineni

Can you confirm the second point. Whether you want to hide -Ve values for this Graph??

May be use something like below

=Sum({<Deviations = {'>0'}>}Deviations)

Or use

=Fabs(Sum(Deviations))

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
spikenaylor1
Creator
Creator
Author

Apologies

I need the -ve values to be shown but just not negative purely so I can have the deviations being shown below the axis and the risks being shown above.

ie.

4

2

0

2

4

6

Anil_Babu_Samineni

Would it possible to share the application? Because, Here Fabs will do same thing as you need

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
spikenaylor1
Creator
Creator
Author

Please find attached the chart

annafuksa1
Creator III
Creator III

!it is not really possible.

check my app with walk a !rounds