topic Dynamic Lin Chart X-Axis in QlikView

Dynamic Lin Chart X-Axis

Tue, 28 Jan 2014 16:08:43 GMT

Hi,

I have chart that plots two expressions :

Line A : sum({<[Indicator Number]={80}, [Sub Indicator]={'ABC'},[rolling_12_month_flag]={1}> }Number)

Line B : sum({<[Indicator Number]={80}, [Sub Indicator]={'XYZ'},[rolling_12_month_flag]={1}> }Number)

Is there anyway to set the minimum x-axis values to whatever the lowest value of these two expressions is minus 250?

Many thanks,

Tom

Re: Dynamic Lin Chart X-Axis

Nicole-Smith — Tue, 28 Jan 2014 16:12:18 GMT

In the Static Min expression box (on the Axes tab):

=rangemin(min(aggr(sum({<[Indicator Number]={80}, [Sub Indicator]={'ABC'},[rolling_12_month_flag]={1}> }Number), YourFirstDimension, YourSecondDimension, etc.)), min(aggr(sum({<[Indicator Number]={80}, [Sub Indicator]={'XYZ'},[rolling_12_month_flag]={1}> }Number), YourFirstDimension, YourSecondDimension, etc.)))-250

You need the aggr() to get the calculation with your dimensions. Listing them in rangemin() will give the min of the mins. Then just subtract 250.

Re: Dynamic Lin Chart X-Axis

MK_QSL — Tue, 28 Jan 2014 16:13:14 GMT

Right Click

Axes

Scale

Tick Min and under Static Min Copy below expression.

IF(sum({<[Indicator Number]={80}, [Sub Indicator]={'ABC'},[rolling_12_month_flag]={1}> }Number))

sum({<[Indicator Number]={80}, [Sub Indicator]={'XYZ'},[rolling_12_month_flag]={1}> }Number),

sum({<[Indicator Number]={80}, [Sub Indicator]={'ABC'},[rolling_12_month_flag]={1}> }Number))-250,

sum({<[Indicator Number]={80}, [Sub Indicator]={'XYZ'},[rolling_12_month_flag]={1}> }Number)-250)