topic Have bought vs. Have Not bought (Indirect Set Analysis) in QlikView

Have bought vs. Have Not bought (Indirect Set Analysis)

tmumaw — Tue, 09 Nov 2010 19:10:01 GMT

Ok forum need your help. I have a screen where I want to show customers who have purchased a material group (selected by the user from a dropdown list), but not this material group (selected by the user from another dropdown list). Can anyone help out there or give me an example?

Thanks

Thom

Have bought vs. Have Not bought (Indirect Set Analysis)

boorgura — Tue, 09 Nov 2010 19:15:37 GMT

Did you try the P() and E() functions in set analysis??

Have bought vs. Have Not bought (Indirect Set Analysis)

tmumaw — Tue, 09 Nov 2010 19:25:23 GMT

I have been looking at them, but not too sure on how to code it because it's based on what the user selected from the list boxes. I have an example Sum({$<Customer = (P({1<Product = {'A'}>})) * (E({1<Product={'D'}>}))>}Sales). This is the example I am trying to work with but I don't understand what I would put in the product 'A' or 'D' because these are fields the user would select.

Thanks

Have bought vs. Have Not bought (Indirect Set Analysis)

tmumaw — Thu, 11 Nov 2010 13:59:04 GMT

Ok. I have tried these stmts with no luck. Could someone please explain what these statements are doing vs what I think they are doing?

sum({$<[Ship To] = p({$<[Material Group Code] ={'002'}>} [Ship To])>} [Subtotal 1] + [Subtotal 2])

sum({$<[Ship To] =E({1<[Material Group Code] ={'010'}>} [Ship To])>} [Subtotal 1] + [Subtotal 2])

sum({$<[Ship To] = P({1<[Material Group Code] ={'002'}>}) * E({1<[Material Group Code] ={'010'}>} [Ship To])>} [Subtotal 1] + [Subtotal 2])

Thanks

Thom