Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search for String combination

Dear Ladies and Gentleman,

I'm searching for days for a solution. The problem is following:

Order | Product | Option | Price | Amount | Date

0001 | A1 | K900,D300 | 5,- | 19 | 1.9.2010

0003 | A1 | B100,D300 | 7,- | 1 | 1.10.2010

0006 | B2 | KS100,L300 | 125,- | 19 | 1.9.2010

If a User selects 2 Options in a Listbox, I just want to sum the Price of all the Orders where this combination appears.

Thank you very much for you help

3 Replies
Not applicable
Author

that two options come from a single listbox??

Not applicable
Author

mOngkz,

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.

But I just want to get the AND relationship.

Not applicable
Author

If you want to get the AND relationship result use p() function

can you provide a sample data??