topic Re: Chart X-axis range wise display in QlikView

Chart X-axis range wise display

Thu, 01 Oct 2015 11:03:36 GMT

Hi,

How can i display range in x-axis like(1-10,10-20,20-30......100) in Bar chart

Mydata is

SALESREPID ORDERId

1 100

2 101

1 102

3 103

1 104

2 105

in my data having total 2600 Orders

I want to display count(SalesRepID) in the above range wise

i am using =class(count(Total OrderID),50,'x')

it showing only one 2600<=x<2650

Please Help me,

Thank you.

Re: Chart X-axis range wise display

SreeniJD — Thu, 01 Oct 2015 11:09:10 GMT

Use Class function. this will work for you

Sreeni

Re: Chart X-axis range wise display

stephenedberkg — Thu, 01 Oct 2015 11:26:15 GMT

go to chart properties -> axis -> set minimum,maximum and step values

refer this attachment

Re: Chart X-axis range wise display

Thu, 01 Oct 2015 11:45:02 GMT

i want to display range in x -axis

not 0,10,20,30

0-10,10-20,20-30

like this

Re: Chart X-axis range wise display

gautik92 — Thu, 01 Oct 2015 11:51:04 GMT

have a look at this

Re: Chart X-axis range wise display

Thu, 01 Oct 2015 11:53:28 GMT

Please send me class function expression ,i am using trail version

Re: Chart X-axis range wise display

gautik92 — Thu, 01 Oct 2015 11:58:06 GMT

Data:

load

replace(Class(ORDERS,10), '<= x <','-') as Range,

Class(ORDERS,10) as GroupRange

Resident Sales;

Re: Chart X-axis range wise display

Thu, 01 Oct 2015 12:00:37 GMT

Thank you

Gowtham