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: 
carolin01
Luminary Alumni
Luminary Alumni

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
PrashantSangle

Hi,

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

11 Replies
MK_QSL
MVP
MVP

You can use like below

NUM(YourExpression, '#.##')

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

Gysbert_Wassenaar

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
carolin01
Luminary Alumni
Luminary Alumni
Author

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

carolin01
Luminary Alumni
Luminary Alumni
Author

Where should I implement this?

PrashantSangle

Hi,

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
carolin01
Luminary Alumni
Luminary Alumni
Author

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

PrashantSangle

Hi,

do one more thing ,

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

regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
MK_QSL
MVP
MVP

Max Dreamer. Today is your Lucky Day !!!

MK_QSL
MVP
MVP

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