Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Luminary
Luminary

Axis Layout

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

1 Solution

Accepted Solutions
Highlighted

Hi,

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

11 Replies
Highlighted
MVP
MVP

You can use like below

NUM(YourExpression, '#.##')

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

Highlighted
MVP & Luminary
MVP & Luminary

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

comm111160.png

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


talk is cheap, supply exceeds demand
Highlighted
Luminary
Luminary

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

Highlighted
Luminary
Luminary

Where should I implement this?

Highlighted

Hi,

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

Highlighted
Luminary
Luminary

Hi,

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

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

My chart now:

Screenshot2.png

Highlighted

Hi,

do one more thing ,

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

regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
MVP
MVP

Max Dreamer. Today is your Lucky Day !!!

Highlighted
MVP
MVP

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