topic Re: Re: Re: data model problem in QlikView

data model problem

Mon, 15 Sep 2014 12:25:03 GMT

hi QV's ,

Please find App below ,

my problem is why i am getting Synthetic key can you please resolve

Re: data model problem

avinashelite — Mon, 15 Sep 2014 12:46:45 GMT

Hi lohitha,

What's your actual requirement??? I saw your data model. Your making it too complicated, your loading the same table again and again. Basically we need to combine all the tables using a SINGLE key, in your case ur using 2 keys name and Date that's why its forming synthetic key.

Re: data model problem

Mon, 15 Sep 2014 12:51:22 GMT

hi avinash ,

i load but after that i am drop but the problem is to avoid key , i am just adding field "Name" and "Date" in a separate variable by using "for loop" and peek . can u sort out this

-lohi

Re: data model problem

Mon, 15 Sep 2014 12:59:53 GMT

hi,

Plz check the data model where "CumulativeSum_Temp-1" is coming from ?

-lohi

Re: data model problem

geert_gelade — Mon, 15 Sep 2014 13:04:45 GMT

That's because the "DROP Table CumulativeSum;" statement is outside you loop.

Re: data model problem

Mon, 15 Sep 2014 13:05:20 GMT

Few way to avoid synthetic keys

1.you can comment unwanted columns .

2. Use aliases to avoid same column name.

3. Can make the composite key from same fields.

Re: data model problem

Mon, 15 Sep 2014 13:12:12 GMT

hi geert ,

if i give "DROP Table CumulativeSum;" in side the loop "table not found" error is coming plz check

-lohi

Re: data model problem

geert_gelade — Mon, 15 Sep 2014 13:21:08 GMT

Can you upload the complete xls-file, now the tab with comissions is missing.

Re: data model problem

Mon, 15 Sep 2014 13:35:52 GMT

plz check above excel file two sheet will be there

-lohi

Re: data model problem

geert_gelade — Mon, 15 Sep 2014 14:18:26 GMT

I still see only on sheet in xls-file...

Re: Re: data model problem

Mon, 15 Sep 2014 14:21:33 GMT

hi , plz find attachment

-lohi

Re: Re: data model problem

Mon, 15 Sep 2014 14:45:38 GMT

hi , any one got the result

-lohi

Re: Re: data model problem

Mon, 15 Sep 2014 15:23:49 GMT

Hi Lohi,

I could see your excel file and could not look at QVW.

But looking at excel tabs I could not understand how are you getting Syn table in Data model.

Could you please attach data model in some other format?

Regards,

Re: Re: data model problem

Mon, 15 Sep 2014 15:27:02 GMT

hi , plz check

Re: data model problem

alex_millan — Mon, 15 Sep 2014 15:40:38 GMT

Perhaps I missed something but, what's the point to create a field to accumulate sales when you can do it after scripting by means of expressions?

Re: Re: data model problem

Mon, 15 Sep 2014 15:52:53 GMT

Hi Lohi,

Now its even more confusing.

I think first you are joining both tabs data from excel then doing some calculation (cumulative).

I think if you will load excel tabs separately then Syn table issue will not arise, if u can share your load script as well then may be I will be able to understand your data model clearly.

Regards,

Re: Re: Re: data model problem

geert_gelade — Mon, 15 Sep 2014 20:06:50 GMT

I suppose you're trying to add the commissions to the base-table based on the interval of the cumulativesales and the key "name-year".

Please find attached a possible solution without looping over the values of name and year, but by using the extended intervalmatch function.