topic Re: How to combine data from different sheets in qlikview in QlikView

How to combine data from different sheets in qlikview

trishita — Wed, 25 Nov 2020 16:16:04 GMT

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

arvind1494 — Tue, 09 Oct 2018 10:51:04 GMT

What exactly you want to do ?

can you share one sample

nasirsaikh — Tue, 09 Oct 2018 10:54:19 GMT

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