topic AW:Re: AND filter in QlikView

AND filter

ppmc — Fri, 06 Nov 2009 14:05:18 GMT

I have an order list with one line per article. As result i need a list with for example all orders with article1 AND article2. Can anyone help me to create an AND filter to the same field?

AND filter

Fri, 06 Nov 2009 15:11:23 GMT

Hi Wolfgang,

please drop a short data example in Excel or so.

Thank´s !

Rainer

AND filter

stephencredmond — Fri, 06 Nov 2009 16:15:01 GMT

If you have a table like this:

OrderID, ArticleID, Date, Price...

And one like this:

ArticleID, ArticleName, ...

Then you could do this:


A2:
Load Distinct OrderID, ArticleID As ArticleID2
Resident Orders;
Left Join Load Distinct ArticleID As ArticleID2, ArticleName As ArticleNameAND
Resident Articles;
Drop Field ArticleID2;

Then you can have "AND" mode in the list box for the ArticleNameAND field.

AW:Re: AND filter

ppmc — Fri, 06 Nov 2009 18:54:30 GMT

Hi Rainer,

thank you fpr your interest. I got the right result with Stephen's answer.

Nice greetings

Wolfgang

AW:Re: AND filter

ppmc — Fri, 06 Nov 2009 18:56:02 GMT

Hi Stephen,

thank you for your example. It works!

Nice greetings

Wolfgang