topic Re: Axis Layout in QlikView

Axis Layout

carolin01 — Wed, 19 Mar 2014 13:38:21 GMT

Hi,

Could anybody help me with my chart layout:

I would like to have tousands seperators on my first axis and my secondary axis should be shown in %.

Unter Numbers in the chart properties I used #.##0 for my values on the first axis and the same shown in Percent for my secondary axis. Nevertheless it is not shown correctly. Also I fixed the max value for my secondary axis to 1.0 but it still shows 1.1.

Any ideas?

Best regards

Carolin

Re: Axis Layout

MK_QSL — Wed, 19 Mar 2014 13:40:23 GMT

You can use like below

NUM(YourExpression, '#.##')

NUM(YourExpression, '#,##0.00%')

Re: Axis Layout

Gysbert_Wassenaar — Wed, 19 Mar 2014 13:41:27 GMT

Try changing the format of the values on the Number tab.

No idea why the static max value isn't honored. It works in my document.

Re: Axis Layout

carolin01 — Thu, 20 Mar 2014 08:59:51 GMT

The number format is correct. I know that usually you would do this here but for some reason it´s not changing anything.

Re: Axis Layout

carolin01 — Thu, 20 Mar 2014 09:00:12 GMT

Where should I implement this?

Re: Axis Layout

PrashantSangle — Thu, 20 Mar 2014 09:06:38 GMT

Hi,

You can write Num() given by MRKachhiaIMP in your expression

Regards,

Re: Axis Layout

carolin01 — Thu, 20 Mar 2014 09:27:59 GMT

Hi,

I tried but it didn´t work. My expression now:

Num((RangeSum(Above($(vCalcTotalYear1), 0, RowNo()))) /( vSumTotalSales), '#,##0.00%')

My chart now:

Re: Axis Layout

PrashantSangle — Thu, 20 Mar 2014 09:33:28 GMT

Hi,

do one more thing ,

Property->Expression->select Expression->select relative

regards,

Re: Axis Layout

MK_QSL — Thu, 20 Mar 2014 14:59:47 GMT

Max Dreamer. Today is your Lucky Day !!!

Re: Axis Layout

MK_QSL — Thu, 20 Mar 2014 15:02:32 GMT

GO to expression tab... instead of expression you can use this ....

Re: Axis Layout

PrashantSangle — Fri, 21 Mar 2014 05:08:10 GMT

Thanks Manish Kachhia

Re: Axis Layout

carolin01 — Fri, 21 Mar 2014 09:55:30 GMT

Trying to be fair: Max Dreamer got the correct answer and Manish Kachhia got 2 helpful answers - I hope this is fair