Multiple vendors same account - Qlik Community

Anonymous · ‎2015-10-26

Hi,

I need to find out different vendors who have the same bank account. I need to show the exceptions only in a table or chart.

So out of the the following numbers, we should highlight only vendor abc, xyz with bank a/c 1 and yyy, sss with bank a/c 2 as exceptions because they have the same bank account.

Thanks

Bank Ac	Vendor
1	abc
1	xyz
2	yyy
2	sss
3	r
4	e
5	q
6	w

Gysbert_Wassenaar · ‎2015-10-26

See attached qvw. Is that what you're looking for?

talk is cheap, supply exceeds demand

MarcoWedel · ‎2015-10-26

Hi,

I'm not sure whether you want to show all records and highlight the double Vendors or just filter to show the relevant Bank Ac / Vendor combinations.

If the latter, then one solution could be:

hope this helps

regards

Marco

Anonymous · ‎2015-10-27

Thanks Marco, it works, appreciate it. If you don't mind and have some free time at hand, would you please explain what exactly you did? The formula is a little confusing for me

Anonymous · ‎2015-10-27

Nothing is attached

Gysbert_Wassenaar · ‎2015-10-27

There really is a document attached. Try refreshing the page.

talk is cheap, supply exceeds demand

MarcoWedel · ‎2015-10-27

Hi,

the set expression restricts the bank accounts to those that belong to more than one vendor.

Try using the search string

=Count(Distinct Vendor)>1

manually to understand:

hope this helps

regards

Marco

swuehl · ‎2015-10-27

Sunny Sahni wrote:

Nothing is attached

Please note that you don't see attachments from within the INBOX of the community forum. You need to click on the title to open the thread, then you should see all attachments, like Gysbert's one.