topic Re: Set the same value for a multiple row in a table in QlikView

Set the same value for a multiple row in a table

Mon, 02 Mar 2015 13:19:11 GMT

Good morning, I would replace tha value of the field DATA FATTURA where CAUSALE = FE for each row.

The field DATA FATTURA must be the same of the value CAUSALE=FE for all the row.

How cai I obtain the result ?

Thanks

Giovanni

Re: Set the same value for a multiple row in a table

anbu1984 — Tue, 03 Mar 2015 02:54:59 GMT

Tbl:

Load [NUMERO FATTURO],CAUSALE, [DATA FATTURA], [DATA INCASSO] From Table;

Join(Tbl)

Load [NUMERO FATTURO],[DATA FATTURA] As [DATA FATTURA FE] Resident Tbl Where CAUSALE = 'FE';

Use [DATA FATTURA FE] in the chart

Re: Set the same value for a multiple row in a table

Tue, 03 Mar 2015 11:40:22 GMT

Hi Anbu, I have tried your solution but don't works.

My scripts is like this:

CNSIT:

LOAD

Num(CNNUFA,000000000) as [NUMERO FATTURA],

CNCAUS as [CAUSALE],

if (match(CNCAUS,'FE'),date (date#(CNDARS & CNDARA &'-'& CNDARM &'-'& CNDARG, 'YYYY-MM-DD'), 'DD-MM-YYYY'),'-') as [DATA FATTURA],

date (date#(CNDTVI,'YYYYMMDD'),'DD-MM-YYYY') as [DATA INCASSO]

FROM

XXXXXXXXXXXX

(qvd);

FADET:

LOAD

date (date#(DFDFA,'YYYYMMDD'),'DD-MM-YYYY') as [DATA FATTURA],

Num(DFNFA,000000000) as [NUMERO FATTURA],

DFCOM as [N° COMMESSA]

FROM

XXXXXXXXXXXX

(qvd);

Re: Set the same value for a multiple row in a table

anbu1984 — Tue, 03 Mar 2015 14:47:37 GMT

Add where clause to this table

FADET:

LOAD

date (date#(DFDFA,'YYYYMMDD'),'DD-MM-YYYY') as [DATA FATTURA],

Num(DFNFA,000000000) as [NUMERO FATTURA],

DFCOM as [N° COMMESSA]

FROM

XXXXXXXXXXXX

(qvd)

Where CAUSALE = 'FE';

Re: Set the same value for a multiple row in a table

Tue, 03 Mar 2015 16:03:17 GMT

The field CAUSALE does not come from the table on which I put the condition.

If I add the where clause it's not work correctly.

And it's wrong to add in the other section beacause I would show the value of the field CAUSALE where is the IN value.