Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart Axis issue?

Hi Folks,

I hava data like this below

1,2,3,4,5,-----100,110,102,103,104

I have used Class function but it is showing like this below

0<=x<10 11<=x<20 21<=x<30 31<=x<40 41<=x<50 51<=x<60 61<=x<70 71<=x<80 81<=x<90 91<=x<100 100<=x<104(instead of More)

I want to show in X-Axis

0-10% 11-20% 21-30% 31-40% 41-50% 51-60% 61-70% 71-80% 81-90% 91-100% More(Above 100)

Can u please suggest me on this.

1 Solution

Accepted Solutions
its_anandrjs
Champion III
Champion III

Hi,

In dimension you can try this ways also assume this example

LOAD

RecNo() as Id,

Rand()*100 as Amt

AutoGenerate(150);

And in the straight table chart

Dim:- =if(Id<100, Replace(Class(Id,10),'<= x <', '-')&'%', 'Above 100')

Expre:- sum(Amt)

But check the expression should calculate % in your expression it is example.

Regards

Anand

View solution in original post

2 Replies
its_anandrjs
Champion III
Champion III

Hi,

You can try this expression and replace the <= x < string and concatenate % symbol but if your expression calculates the % values then it is better you can use this expression

=Replace(Class(Attendees,10),'<= x <', '-')&'%'

Regards

Anand

its_anandrjs
Champion III
Champion III

Hi,

In dimension you can try this ways also assume this example

LOAD

RecNo() as Id,

Rand()*100 as Amt

AutoGenerate(150);

And in the straight table chart

Dim:- =if(Id<100, Replace(Class(Id,10),'<= x <', '-')&'%', 'Above 100')

Expre:- sum(Amt)

But check the expression should calculate % in your expression it is example.

Regards

Anand