Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rcandeo
Creator III
Creator III

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
sunny_talwar

13 Replies
sunny_talwar

Like this?

Capture.PNG

rcandeo
Creator III
Creator III
Author

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

rcandeo
Creator III
Creator III
Author

Number format, I got it. Thank You.

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

What's missing then?

anushree1
Specialist II
Specialist II

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.

sunny_talwar

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

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

Anil_Babu_Samineni

How about this format

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)