topic Re: X Axis min point start from 20% in QlikView

X Axis min point start from 20%

paulyeo11 — Mon, 29 Jul 2013 11:02:37 GMT

Hi All

I try to changeX Axis min by enter 20% , it does not work. any idea ?

sivarajs — Mon, 29 Jul 2013 11:06:57 GMT

You might have checked forced 0 option in axes tab of properties.Uncheck and set the changes

Mon, 29 Jul 2013 11:07:59 GMT

This can be possible by set the Static min, max and set values for the expression "Scale" area under Axes tab. Also, uncheck the option "Forced 0".

paulyeo11 — Mon, 29 Jul 2013 11:09:48 GMT

Hi Ven

How can i make use of Argg function to make it dynamic ? my expression as below :-

(

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1

)

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1

Paul

Siva_Sankar — Mon, 29 Jul 2013 11:12:42 GMT

Under Axes tab, uncheck forced 0 option and try. Regards. siva

kaushiknsolanki — Mon, 29 Jul 2013 11:14:25 GMT

Hi,

For min value try this.

Min(Aggr((

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1 )

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1),Dimensions)

For maximum value

Max(Aggr((

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1 )

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1),Dimensions)

Regards,

Kaushik Solanki

paulyeo11 — Mon, 29 Jul 2013 12:48:31 GMT

Hi Kau

Many thank , it work fine.

Paul