Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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';
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.