Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

Hi All

Chart 1 I want to plot this.  it is a scatter chart Y axis Budget variance % X axis is the sales YTD.

Table 1 i have Budget Bariance. at 3th column and YTD sales at 2nd column.

I create Chart 2 , all expression are already correct , only Y Axis to  Budget % display wrong.

Table 2 show only 2 group achieve target , but the chart 2 display group 1 achieve budget 100%. But from the Table 1 it shown -51% out of budget.

Hope some one can advise me.

Paul

6 Replies
paulyeo11
Valued Contributor II

Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

my qvw

Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

Can i know which expression you are using for Budget variance %

Life is so rich, and we need to respect to the life !!!
paulyeo11
Valued Contributor II

Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

(

SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales)

/

SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales_target)

)

-1

above is the expression i use for Budget variance %

Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

Is that, sales_target is Link Table (Key) or direct value?

Life is so rich, and we need to respect to the life !!!
paulyeo11
Valued Contributor II

Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

It is direct value. As you notice that this field use in table 1 , it display correct %.

paulyeo11
Valued Contributor II

Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

Hi Anil

The Budger vari % expression work fine in table , does not work in scatter chart , can it due what ? Or the expression need to add condition ?

I also notice the error is instead of + ve % it return -ve % , can it cause by the expression is not correct ?

May be some one like to share with me.

Paul

Sent from my iPhone

Community Browser