Discussion Board for collaboration related to QlikView App Development.
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 ?
Load [NUMERO FATTURO],CAUSALE, [DATA FATTURA], [DATA INCASSO] From Table;
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:
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]
date (date#(DFDFA,'YYYYMMDD'),'DD-MM-YYYY') as [DATA FATTURA],
Num(DFNFA,000000000) as [NUMERO FATTURA],
DFCOM as [N° COMMESSA]
Add where clause to this table
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.