Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set the same value for a multiple row in a table

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

4 Replies
Highlighted
Master III
Master III

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

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

Highlighted
Not applicable

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

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);

Highlighted
Master III
Master III

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

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';

Highlighted
Not applicable

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

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.