topic Re: data model problem in QlikView

data model problem

arulsettu — Mon, 13 Apr 2015 03:46:33 GMT

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

Re: data model problem

arulsettu — Mon, 13 Apr 2015 04:20:25 GMT

any one please suggest some idea

Re: data model problem

petter — Mon, 13 Apr 2015 04:31:16 GMT

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

Re: data model problem

petter — Mon, 13 Apr 2015 04:35:08 GMT

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.

Re: data model problem

arulsettu — Mon, 13 Apr 2015 04:37:56 GMT

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

thanks

Re: data model problem

arulsettu — Mon, 13 Apr 2015 04:43:25 GMT

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

Re: data model problem

arulsettu — Mon, 13 Apr 2015 05:06:02 GMT

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

Re: data model problem

petter — Mon, 13 Apr 2015 06:19:28 GMT

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...

Re: data model problem

arulsettu — Mon, 13 Apr 2015 06:23:33 GMT

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

thanks

Re: data model problem

petter — Mon, 13 Apr 2015 06:30:33 GMT

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

Re: data model problem

arulsettu — Mon, 13 Apr 2015 06:43:23 GMT

hi peter please check this

Re: data model problem

arulsettu — Mon, 13 Apr 2015 06:56:39 GMT

Petter the LOB_ACODE and ACNT_FLEX_06 is not getting associated thats the reason i think