topic Search for String combination in QlikView https://community.qlik.com/t5/QlikView/Search-for-String-combination/m-p/199587#M58461 <HTML><HEAD></HEAD><BODY><P>If you want to get the AND relationship result use p() function</P><P>can you provide a sample data??</P></BODY></HTML> Wed, 24 Nov 2010 09:38:23 GMT 2010-11-24T09:38:23Z Search for String combination https://community.qlik.com/t5/QlikView/Search-for-String-combination/m-p/199584#M58458 <HTML><HEAD></HEAD><BODY><P>Dear Ladies and Gentleman,</P><P>I'm searching for days for a solution. The problem is following:</P><P>Order | Product | Option | Price | Amount | Date</P><P>0001 | A1 | K900,D300 | 5,- | 19 | 1.9.2010</P><P>0003 | A1 | B100,D300 | 7,- | 1 | 1.10.2010</P><P>0006 | B2 | KS100,L300 | 125,- | 19 | 1.9.2010</P><P></P><P>If a User selects 2 Options in a Listbox, I just want to sum the Price of all the Orders where this combination appears.</P><P></P><P>Thank you very much for you help</P></BODY></HTML> Wed, 24 Nov 2010 06:34:05 GMT https://community.qlik.com/t5/QlikView/Search-for-String-combination/m-p/199584#M58458 2010-11-24T06:34:05Z Search for String combination https://community.qlik.com/t5/QlikView/Search-for-String-combination/m-p/199585#M58459 <HTML><HEAD></HEAD><BODY><P>that two options come from a single listbox??</P></BODY></HTML> Wed, 24 Nov 2010 08:38:20 GMT https://community.qlik.com/t5/QlikView/Search-for-String-combination/m-p/199585#M58459 2010-11-24T08:38:20Z Search for String combination https://community.qlik.com/t5/QlikView/Search-for-String-combination/m-p/199586#M58460 <HTML><HEAD></HEAD><BODY><P>mOngkz,</P><P>thanks for your quick reply. I wondering, that I get a different result using your expression. I will get all the others which have just option1 OR option2 and which have option1 AND 2.</P><P></P><P>But I just want to get the AND relationship.</P></BODY></HTML> Wed, 24 Nov 2010 08:46:11 GMT https://community.qlik.com/t5/QlikView/Search-for-String-combination/m-p/199586#M58460 2010-11-24T08:46:11Z Search for String combination https://community.qlik.com/t5/QlikView/Search-for-String-combination/m-p/199587#M58461 <HTML><HEAD></HEAD><BODY><P>If you want to get the AND relationship result use p() function</P><P>can you provide a sample data??</P></BODY></HTML> Wed, 24 Nov 2010 09:38:23 GMT https://community.qlik.com/t5/QlikView/Search-for-String-combination/m-p/199587#M58461 2010-11-24T09:38:23Z