Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

data model problem

hi QV's ,

Please find App below ,

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

16 Replies
Not applicable
Author

hi , plz find attachment

-lohi

Capture.PNG.png

Not applicable
Author

hi , any one got the result

-lohi

Not applicable
Author

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,

Not applicable
Author

hi , plz check

alex_millan
Creator III
Creator III

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?

Not applicable
Author

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,

geert_gelade
Creator
Creator

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.