topic Re: budget amount problem in QlikView

budget amount problem

arulsettu — Mon, 13 Apr 2015 05:59:54 GMT

Hi i am calculating actual and budget amount.

my budget table contain amount filed like bd_jan, bd_feb, bd_mar.....bd_dec .

so as per Jagan suggestion i did like this

Temp:

CrossTable(Month, Bud_amount,6)

LOAD

COMP_CODE & '-' &LOB_CODE as %key,

LOB_CODE,

BD_YEAR,

BD_TYPE,

BD_CR_DT,

BD_CR_UID,

BD_JAN,

BD_FEB,

BD_MAR,

BD_APR,

BD_MAY,

BD_JUN,

BD_JUL,

BD_AUG,

BD_SEP,

BD_OCT,

BD_NOV,

BD_DEC

FROM

(qvd);

//to make common month for trans detail and budget

Concatenate(Trans_detail)

LOAD

month(bud_date) as Bd_monthname;

LOAD*,

Match(Capitalize(Right(Month, 3)), 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec') AS bd_month,

MakeDate(BD_YEAR, Match(Capitalize(Right(Month, 3)), 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')) AS bud_date

Resident Temp;

DROP TABLE Temp;

to create common calendar by concatenating budget and actual table i am able to get correct result for both actual and budget.

now my problem is i can able to get budget amount for budget_type=general expenses.

sum({<BD_TYPE={'GEN_ADMIN_EXP'}>}Bud_amount).

for budget_type=gross_premium it showing only zero.

sum({<BD_TYPE={'Gross_Premium'}>}Bud_amount)

can any one suggest me why?

thanks

Re: budget amount problem

jonathandienst — Mon, 13 Apr 2015 06:04:31 GMT

Without being able to see your source data an complete load script, the cause is anyone's guess...

Re: budget amount problem

arulsettu — Mon, 13 Apr 2015 06:10:31 GMT

Hi Jonathan,

please check this app !

Re: budget amount problem

arulsettu — Mon, 13 Apr 2015 06:24:18 GMT

is this app enough please let me know

Re: budget amount problem

arulsettu — Mon, 13 Apr 2015 06:45:00 GMT

plz someone suggest

thanks

Re: budget amount problem

arulsettu — Mon, 13 Apr 2015 07:18:04 GMT

if i select LOB_CODE from budget table i can able to get the budget amount alone. not actual vale.

and if i select the ACNT_FLEX_06 i can get actual value alone not budget value.

these two fields having same values

account and budget table are linked

can anyone suggest whats wrong here

thanks

Re: budget amount problem

arulsettu — Mon, 13 Apr 2015 08:19:11 GMT

any ideas plz its emergency....

Re: budget amount problem

arulsettu — Mon, 13 Apr 2015 14:54:23 GMT

any help guys