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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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