topic mirror chart in QlikView

mirror chart

Wed, 25 Nov 2020 16:16:04 GMT

i have a chart and i want show it mirror. i add a "-"(negative symbol) to start expression. its work but show negative symbol on chat

must not show negative symbol

Re: mirror chart

sunny_talwar — Tue, 15 Aug 2017 11:16:46 GMT

Would you be able to share a sample to test this out?

Re: mirror chart

Anil_Babu_Samineni — Tue, 15 Aug 2017 11:18:13 GMT

Remove - Sign from your Expression, May be?

Re: mirror chart

stigchel — Tue, 15 Aug 2017 11:34:28 GMT

In the Number tab of the chart's properties in the format pattern for this expression repeat the pattern with a ";" in between e.g.

#,##0;#,##0

Re: mirror chart

Tue, 15 Aug 2017 13:21:10 GMT

my version is 12 and dont have number tab

Re: mirror chart

Tue, 15 Aug 2017 13:22:18 GMT

when i remove "-" it is Ascending but i need DeAscending

Re: mirror chart

Tue, 15 Aug 2017 13:26:30 GMT

i dont cant

Re: mirror chart

MarcoWedel — Tue, 15 Aug 2017 22:52:13 GMT

maybe helpful:

Bar Chart (upside down)

regards

Marco

Re: mirror chart

stigchel — Wed, 16 Aug 2017 10:19:04 GMT

Really? Well than use in your expression the num function

Num(-YourExpression,'#,##0;#,##0')

Re: mirror chart

Wed, 16 Aug 2017 12:27:42 GMT

thankyou but its not helpful

its for bar and my chart is line

please help me

i attach my file

regard

Re: mirror chart

sunny_talwar — Wed, 16 Aug 2017 12:32:58 GMT

Check out the attached

May sure to add a static step on the Axes tab

Re: mirror chart

Wed, 16 Aug 2017 14:22:07 GMT

its very good thank you

please say what is Num(-[Actual Depth], '#,##0;#,##0') and static step

Re: mirror chart

sunny_talwar — Wed, 16 Aug 2017 14:25:52 GMT

Num is a formatting function where I am saying that positive and negative numbers are both formatted the same way (essentially the negative numbers are formatted without a minus sign). and Static step is used to determine the distance between each point on the x or y axis based on which static step you are working with.