topic Re: Distribution in QlikView

Distribution

spividori — Tue, 24 Jan 2017 13:44:13 GMT

Hi.

I have two tables, they are the following:

Table1:

Table2:

I need to distribute the amounts of table one in table two, as follows.

The data in both tables must be sorted by date desc.

This is an example, both tables have many data to process as the example.

I attach the sample data in Excel spreadsheets.

Can someone help me with this?

Regards.

Re: Distribution

krishna20 — Tue, 24 Jan 2017 13:47:36 GMT

Hi Sandro,

Why dont you use link table concept here

Thanks

Re: Distribution

spividori — Tue, 24 Jan 2017 13:55:30 GMT

Hi, KALYAN.

Thanks for answering.

Sorry, I do not understand, how would that be?.

Regards.

Re: Distribution

krishna20 — Wed, 25 Jan 2017 04:26:02 GMT

Hi could you please explain how you calculate importcal column

Thank,

Ram

Re: Distribution

spividori — Wed, 25 Jan 2017 10:26:52 GMT

Hi.

For the calculation of the column "AmountCalc" I take from the "Importe" column of Table1 and must be distributed in relation to the "ImpImport" column of Table2.

I hope you understand me, my English is poor.

Regards.