topic Re: Data Modelling in QlikView

Data Modelling

krishna20 — Sun, 22 Mar 2015 10:28:19 GMT

Hi Friends,

Please find the attachment for the image of tables .

The Link from A to B is a key which is like primary key and A to C also as same. In Table D we are having company,Division,Business,Product codes and their description along with the amount. The same Information in Tables E and F also. But, The amount will be differ according to the description in three tables. Table A is linked to D, E, F by creating composite key as Company code,Product code,Business Code,Division Code.

I Need to show the calculated amounts in a single pivot chart with the description and year. I'm getting the repeated amounts when showing it. Kindly help me out how can we change the link between tables.

Regards

Krishna

Re: Data Modelling

preminqlik — Sun, 22 Mar 2015 10:45:33 GMT

post sample data

Re: Data Modelling

krishna20 — Sun, 22 Mar 2015 11:23:12 GMT

Hi,

Please find the sample file and guide me further.

Regards

Krishna

Re: Data Modelling

prieper — Sun, 22 Mar 2015 17:27:04 GMT

is it necessary to upload 40MB of sample data?

Peter

Re: Data Modelling

krishna20 — Mon, 23 Mar 2015 08:16:34 GMT

Hi Peter,

Please find the below attachment ,I compressed the data as much.

Regards

Krishna