Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hi all i am attaching my qvw it have synthatic keys please give me the best answer for this

hi all i am attaching my qvw it have synthatic keys please give me the best answer for this

Datamodel have synthatic keys give solution this

13 Replies
prma7799
Master III
Master III

Can you attach excel file ?

prma7799
Master III
Master III

Or you can Try

1 Qualify operator for Customer table

2 Rename Unit Price field from Order Details

3 remove table Product which is took two times

4 need to rename some field from employees

Thanks

PM

Not applicable
Author

hi prashantbi,

                              that  data is fetched from ms access. so no excel file.

prma7799
Master III
Master III

Hi Raman,

I am unable to download this MDB file.

Thanks

PM

prma7799
Master III
Master III

Try this... and please let me know.

Not applicable
Author

thanks prashantbi, still there some synthetic keys is there you  applied qualify statement and renamend fields.

this is enough scripting side?

can i develop dashboard ?

advance Thanks

ramana

Not applicable
Author

hi prashantbi,

                 we can download and we can access into qlikview using ms access.

Thanks

Ramana

prma7799
Master III
Master III

Yes. If all synthetic keys are remove then you can develop your dashboard.

prma7799
Master III
Master III

Yes but here I unable to download mdb file .

Do one thing convert all table into excel file and send it to me.

Thanks

PM