Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rcandeo
Contributor II

line chart order

Stupid question, but I never changed and not finding where can I invert the order of this line chart?

it is like this:

line chart.jpg

and I need inverted on y axes where 1 is on the top and 3 on the bottom

1 Solution

Accepted Solutions

Re: line chart order

Like this?

Capture.PNG

13 Replies

Re: line chart order

Like this?

Capture.PNG

rcandeo
Contributor II

Re: line chart order

yes, but I have negative values now. how to show only positives?

rcandeo
Contributor II

Re: line chart order

Number format, I got it. Thank You.

Re: line chart order

You can use fabs or number format like (your format)

If your question is answered please put sunny answer as correct answer and close this thread

Life is so rich, and we need to respect to the life !!!

Re: line chart order

What's missing then?

anushree1
Contributor II

Re: line chart order

Hi Sunny,

Can you please explain the usage of dual function here, I know the standard behavior of dual i.e., for numeric representations for calculations on strings.

But this usage seems quite different and I don not seem to understand the logic here.

Re: line chart order

Still using the dual for the same thing. I am assigning each of the Value a negative notation, but for displaying purposes, I just want to continue showing the positive number. So here the text is just a actual non-negatived value. This helps me show the chart below 0 but it still continue to show positive number for the value on the axis. If I don't use dual you will see -1, -2, -3 on the axis instead of 1, 2, 3.

I am not sure how to explain this any better.

HTH

Best,

Sunny

rcandeo
Contributor II

Re: line chart order

Sorry, I was out last days. I have one graph that works, but other graph has negative values. I used format as number and this pattern: ###########,###;##########,###

line chart.jpg

Re: line chart order

How about this format

###########,###;(##########,###)

Life is so rich, and we need to respect to the life !!!
Community Browser