topic Re: Same Approver test in QlikView

Same Approver test

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

Hi,

I want to show exceptions in a table or chart where approver 1 is same as approver 2.

I tried making a list box with the expression =if(app1=app2, 1,0)

I got 1 and 0, when I click on 1 I get the right output, but when I click on 0 I get 1 record of the option 1

Attached the excel and temp qvw. If you click on 0, lyn = lyn should not come.

If you could suggest any other way also, that would be welcome

Thanks

Re: Same Approver test

Kushal_Chawda — Mon, 09 May 2016 07:12:06 GMT

try this

Data:

LOAD SSO,

if( trim(lower(app1))= trim(lower(app2)),1,0) as Flag

FROM Table

Re: Same Approver test

MindaugasBacius — Mon, 09 May 2016 07:23:30 GMT

LOAD sso, 
     app1, 
     app2,
     if(PurgeChar(Lower(app1), ' ') = PurgeChar(Lower(app2), ' '), 1, 0) as Flag 
FROM

(ooxml, embedded labels, table is Sheet1);

Check the attachment.