topic Re: line chart order in QlikView

line chart order

rcandeo — Thu, 22 Sep 2016 19:50:52 GMT

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

it is like this:

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

Re: line chart order

sunny_talwar — Thu, 22 Sep 2016 20:30:43 GMT

Like this?

Re: line chart order

rcandeo — Fri, 23 Sep 2016 02:20:53 GMT

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

Re: line chart order

rcandeo — Fri, 23 Sep 2016 02:28:53 GMT

Number format, I got it. Thank You.

Re: line chart order

Anil_Babu_Samineni — Fri, 23 Sep 2016 04:04:20 GMT

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

Re: line chart order

sunny_talwar — Fri, 23 Sep 2016 07:35:55 GMT

What's missing then?

Re: line chart order

anushree1 — Fri, 23 Sep 2016 08:31:43 GMT

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

sunny_talwar — Mon, 26 Sep 2016 00:22:04 GMT

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

Re: line chart order

rcandeo — Mon, 26 Sep 2016 10:46:46 GMT

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: ###########,###;##########,###

Re: line chart order

Anil_Babu_Samineni — Mon, 26 Sep 2016 10:49:58 GMT

How about this format

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

Re: line chart order

sunny_talwar — Mon, 26 Sep 2016 13:08:53 GMT

What exactly is the issue? the axis?

Re: line chart order

rcandeo — Mon, 26 Sep 2016 17:53:30 GMT

yes, do you see the negative values at the left?

Re: line chart order

sunny_talwar — Mon, 26 Sep 2016 17:57:25 GMT

Those can be fixed by using a static step on the axis tab. Can you try adding a 1 there to see if the axis changes from negative values to positive values?

Re: line chart order

rcandeo — Mon, 26 Sep 2016 18:29:23 GMT

perfect, thank you