How to combine data from different sheets in qlikview

[trishita]

Is it possible to use or combine data between two different sheets in a new sheet in qlikview?

[arvind1494]

What exactly you want to do ?

can you share one sample

[nasirsaikh]

yes you use can use like blow Concatenate function

   Data:

Load Distinct

    'ACCOUNT NUMBER' as ColA,

    OST_SUB_ACNT_CODE as ColB

    FROM [lib://DEB/DATA.qvd](qvd);

    Concatenate(Data)

    Load Distinct

    'ACCOUNT NAME' as ColA,

    CUST_NAME as ColB

        FROM [lib://DEB/DATA1.qvd](qvd);

    Concatenate(Data)  

    Load Distinct

    'Total Outstanding for the period is ' as ColA,

    Num(Sum(ORIGINAL_AMOUNT),'#,##0') as ColB

        FROM [lib://DEB/DATA2.qvd](qvd);