topic Re: Issue with Flag in QlikView

Issue with Flag

arusanah — Wed, 20 May 2015 21:30:57 GMT

HI ,

I have requirement to create a table from data coming from two source files with additional column as flag.

sheet 1 of excel document has data coming from one source .

sheet 2 has data coming from another source

sheet 3 is the output table i want to create after comparing first two sheets .

i did tried my best but facing two problems

1) flag value are not being displayed properly

2) while creating output table my resident load fail...

pls help

sunny_talwar — Thu, 21 May 2015 01:34:20 GMT

Try this:

cust:

LOAD distinct Customer,

If(Len(Trim(Customer)) = 0, Null(), 0) as PayerFlag

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

Join(cust)

LOAD Cust as Customer

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet2);

Test1:

NoConcatenate

LOAD Customer,

If(IsNull(PayerFlag), 1, PayerFlag) as PayerFlag

Resident cust;

DROP Table cust;

Output:

arusanah — Thu, 21 May 2015 02:17:21 GMT

Thank you so much Sunindia !!! works for me

qlikviewwizard — Thu, 21 May 2015 04:46:12 GMT

Please mark as Answered to close the thread.

arusanah — Fri, 22 May 2015 04:57:14 GMT

i would have loved to close this issue but im still struggling with it ! sunindia's replay was close enough but not what i exactly want !

sunny_talwar — Fri, 22 May 2015 09:17:22 GMT

So then what exactly are you looking to do???