topic Re: Multiple vendors same account in QlikView

Multiple vendors same account

Anonymous — Mon, 26 Oct 2015 10:38:43 GMT

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

Re: Multiple vendors same account

Gysbert_Wassenaar — Mon, 26 Oct 2015 18:00:13 GMT

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

Re: Multiple vendors same account

MarcoWedel — Mon, 26 Oct 2015 22:25:17 GMT

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

Re: Multiple vendors same account

Anonymous — Tue, 27 Oct 2015 07:45:29 GMT

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

Re: Multiple vendors same account

Anonymous — Tue, 27 Oct 2015 07:46:33 GMT

Nothing is attached

Re: Multiple vendors same account

Gysbert_Wassenaar — Tue, 27 Oct 2015 16:40:24 GMT

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

Re: Multiple vendors same account

MarcoWedel — Tue, 27 Oct 2015 21:20:11 GMT

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

Re: Multiple vendors same account

swuehl — Tue, 27 Oct 2015 21:25:22 GMT

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.