data model problem

[arulsettu]

Hi,

I am trying to create a data model to calculate budget amount.

i am having budget table. in that i did

budget:

COMP_CODE & LOB_CODE as %Key

account table:

ACNT_COMP_CODE & ACNT_CODE  as %key

up to this fine. now i need to calculate gross premium for budget.

to create a common calendar i concatenated the budget table to Trans_detail table.

now my budget amount is zero. if i remove concatenation budget is showing but actual amount is zero.

can anyone please tell whats is wrong here. its urgent.....

thanks

[arulsettu]

any one please suggest some idea

[petter]

QlikView is case sensitive with fields so if you intend %Key and %key  to be the same field it will not happen.

[petter]

When you create keys by concatenating two or more fields make sure you use a separator between the fields so you dont run into problems with getting key values that are similar but should be different.

[arulsettu]

Thanks for replying Petter. i did the changes but no result. can you check the app if i did any other mistake please

thanks

[arulsettu]

budget amount is showing for another type. but its not showing for current type that i am trying

[arulsettu]

i am getting budget amount for

budget type=general and other expenses

and i am getting zero for budget type = gross premium

can anyone tell me why

thanks

[petter]

I am not sure that it is wise to mix budget which has granularity of month with the trans details which has a different granularity... But it is a bit hard to judge without any test or demo-data ... just looking at the data model and load script I mean.

Do you have some limited or scrambled test-data? You know that QlikView has support for scambling your data so it "rather safe" to share anyway...

[arulsettu]

Thanks Petter but the data is large sorry its not possible to share

thanks

[petter]

Unless you can make a few rows of mock-up data in the tables involved I don't think I can help you more... sorry