Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 ];
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.
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 ];
class is a good way to do this
even you could customized X to RPM like attached one