topic How to create the X-axis like this? in QlikView

How to create the X-axis like this?

Thu, 27 Nov 2014 23:50:47 GMT

Hi I'm trying to re-create this graph: 14ga.png

What expression can I use to create an x-axis like that?

I'm currently ending up with a graph like: 123a.png

Anyone have any ideas?

Re: How to create the X-axis like this?

jagan — Fri, 28 Nov 2014 02:00:02 GMT

Hi,

Check Class() in Qlikview Help file

class(expression, interval [ , label [ , offset ]])

Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'

Regards,

Jagan.

Re: How to create the X-axis like this?

Fri, 28 Nov 2014 05:07:37 GMT

Hi,

Create the chart with

Class(RPM,1500) as Dimension

and Sum(Duration) as Expression

Please refer the below example

load * inline [

RPM,Duration

1000,30

2000,40

4000,50

6000,70 ];

Re: Re: How to create the X-axis like this?

SunilChauhan — Fri, 28 Nov 2014 06:16:43 GMT

class is a good way to do this

even you could customized X to RPM like attached one