topic Re: Script Logic in QlikView

Script Logic

sona_sa — Sun, 10 May 2015 12:46:54 GMT

Hi,

I have 2 sheet, i.e Sheet1 and Sheet2. In Sheet1 One field is Test and in another Sheet2, One field is Test2.

I have to match the value with Sheet 1 and Sheet 2 and create a new field, i.e Test1.

Like : If value of Sheet 1 : Test = Sheet 2 : Test2, then return me 1, else return me 0. For more reference, Please find the attached xls.

Output filed is also there, i.e - Test1.

Thanks in advance.

Re: Script Logic

sunny_talwar — Sun, 10 May 2015 13:49:30 GMT

Is this what you are looking for? (PFA)

Best,

Sunny

Re: Script Logic

sona_sa — Sun, 10 May 2015 13:58:08 GMT

Yes, but can we do the same by using nested if - else condition and group by function.

Thanks for reply.

Re: Script Logic

MarcoWedel — Sun, 10 May 2015 18:48:00 GMT

Hi,

another solution could be:

tabSheet2:
LOAD Test2
FROM [https://community.qlik.com/servlet/JiveServlet/download/771370-163411/Test.xlsx]
(ooxml, embedded labels, table is Sheet2);

tabSheet1:
LOAD Test,
    fabs(Exists(Test2,Test)) as Test1
FROM [https://community.qlik.com/servlet/JiveServlet/download/771370-163411/Test.xlsx]
(ooxml, embedded labels, table is Sheet1);

hope this helps

regards

Marco

Re: Script Logic

MarcoWedel — Sun, 10 May 2015 20:12:09 GMT

or just

-Exists(Test2,Test) as Test1

instead of

fabs(Exists(Test2,Test)) as Test1

hope this helps

regards

Marco