Same Approver test

[Anonymous]

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

[Kushal_Chawda · Accepted solution]

try this

Data:

LOAD SSO,

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

FROM Table

[MindaugasBacius]

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.