topic Chart Axis issue? in QlikView

Chart Axis issue?

Thu, 25 Dec 2014 09:28:17 GMT

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.

Re: Chart Axis issue?

its_anandrjs — Thu, 25 Dec 2014 21:03:32 GMT

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

Re: Chart Axis issue?

its_anandrjs — Thu, 25 Dec 2014 21:35:48 GMT

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