topic Re: Need help to build a table in QlikView

Need help to build a table

Tue, 06 May 2014 07:04:30 GMT

Hello,

I'm having trouble to build a table as I want.

Here is my problem, I have a table like this one:

Canal	Client	Article	Qté
20	1	A	10
20	1	B	20
20	2	A	15

And another table like this one:

Article	Prix
A	0,1
B	0,2
C	0,3

All I want to do is to put in a table the content of the first table and add a column calculated using the second table.

My result table must be like this:

Canal	Client	Article	Qté	Prix * Qté
20	1	A	10	1
20	1	B	20	4
20	2	A	15	1,5

Can anyone help me to do this? Maybe the mapping could be a solution?

Thanks,

Best regards,

Loïc

Re: Need help to build a table

Tue, 06 May 2014 07:12:50 GMT

Hi,

1. You will be directly able to build a chart just by loading these tables. Article will get associated. (OR)

2. Use ApplyMap to map Prix to the table. (OR)

3. Use join between these tables.

Thanks,

Prabhu

Re: Need help to build a table

ashfaq_haseeb — Tue, 06 May 2014 07:14:58 GMT

Hi,

Please find the attached.

Regards

ASHFAQ

Re: Need help to build a table

lukaspuschner — Tue, 06 May 2014 07:15:34 GMT

try this:

First:

load *

From Table1;

join(First)

load *

From Table2;

noconcatenate

Seccond:

Load *,

Prix * qte as Fieldname

Resident First;

drop table First;

Re: Need help to build a table

tresB — Tue, 06 May 2014 07:16:01 GMT

If you directly load these two tables, they would be associated by Article field as Key. Then you can get the same in the front end simply using straight table.

Re: Need help to build a table

Tue, 06 May 2014 07:16:36 GMT

TABLE1:

load * inline [
canal,client,article,Qte
20,1,A,10
20,1,B,20
20,2,A,15
];

TABLE2:
LOAD * INLINE [
article,Prix
A,.1
B,.2
C,.3
];

Create a straight table and insert Canal,Client,Article,Qte as dimension and in expression have the following formula:

(Prix) * (Qte) and select No totals on the bottom.

Re: Need help to build a table

nirav_bhimani — Tue, 06 May 2014 07:19:14 GMT

Table1:

Load

Canal,

Client,

Article,

Qte

from Table1;

Left Join

Load

Article,

Prix

From Table2;

Final:

Load * , Prix* Qte as CalcField Resident Table1;

Resident Table1;

Hope this will help to resolve your problem.

Regards,

Nirav Bhimani

Re: Need help to build a table

Tue, 06 May 2014 07:20:28 GMT

Try as below, and the put all fields in table box:

table1:

LOAD * INLINE [

Canal,Client,Article,Qte

20,1,A,10

20,1,B,20

20,2,A,15

];

table2:

left join (table1)

LOAD * INLINE [

Article,Prix

A,0.1

B,0.2

C,0.3

];

final:

LOAD

Canal,Client,Article,Qte,Prix*Qte as "Prix*Qte"

Resident table1;

drop table table1;

Thanks,

Angad

Re: Need help to build a table

Tue, 06 May 2014 07:35:33 GMT

Hi,

You can do like this

Temp:

Load

Canal,

Client,

Article,

Qte

from TableA;

Left Join

Load

Article,

Prix

From Table B;

Final:

Load * , Prix* Qte as CalcField

Resident Temp;

Drop table Temp;

Hope this will help !!.

Regards,

Deepak

Re: Need help to build a table

Tue, 06 May 2014 07:57:50 GMT

HI ALL

I did as per the attached file kindly suggest if any limitation in doing so

Thanking You

Vinayagam