Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

How to combine data from different sheets in qlikview

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

2 Replies
arvind1494
Specialist
Specialist

What exactly you want to do ?

can you share one sample

nasirsaikh
Creator
Creator

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