topic Re: Bar Chart above and below axis in QlikView

Bar Chart above and below axis

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

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

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

any help please kind people

Re: Bar Chart above and below axis

Anil_Babu_Samineni — Mon, 27 Feb 2017 15:26:59 GMT

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

Re: Bar Chart above and below axis

spikenaylor1 — Mon, 27 Feb 2017 15:31:35 GMT

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)

Re: Bar Chart above and below axis

Anil_Babu_Samineni — Mon, 27 Feb 2017 15:35:47 GMT

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))

Re: Bar Chart above and below axis

spikenaylor1 — Mon, 27 Feb 2017 15:45:48 GMT

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.

Re: Bar Chart above and below axis

Anil_Babu_Samineni — Mon, 27 Feb 2017 15:47:51 GMT

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

Re: Bar Chart above and below axis

spikenaylor1 — Mon, 27 Feb 2017 16:08:11 GMT

Please find attached the chart

Re: Bar Chart above and below axis

annafuksa1 — Mon, 27 Feb 2017 16:24:13 GMT

!it is not really possible.

check my app with walk a !rounds