How to make selections mean 'OR' instead of 'AND' set conditions
Is there a way to have a listbox that will be used as selection criteria be used as an 'OR' selection and not an 'AND' selection?
For example, normally when I do a selection in the listbox and select 3 choices what I am left with in my corresponding chart is the data which meets all 3 selections. So if the listbox contains a list is of skus and I select 3 skus, and the chart is purchases by customers of those skus, I will only see purchases for customers who have bought all 3 skus. I would like to see purchases for customers who have bought ANY of the 3 skus, not only those buying ALL 3 skus.
It seems like I should be able to do this somehow but I can't find anything. Please help!
When I reply to this thread I don't see anywhere to 'add attachment'. Can anyone tell me how to attach my sample qvw so you can look at it to help me with my expression issue?
Ok, thank you. Found the problem - that option is not there when I click reply on the thread through my Inbox. When I go out to the home page and browse back through to find this thread and reply that way, I see the Use advanced editor option and could do it. So...now attached is the sample qvw. You will see with one event selected I get exactly the data I want, but with 2 events selected (so my customers may show in both cases) the data goes away.
Again, the customers and the orders may be duplicated in both selected events as I'm looking to see purchases made within a certain time period after these events and compare both events.
HI - if anyone can please help me now that I've got the attachment on the thread - it's urgent. I need to see what I'm doing wrong with either my expressions or chart. I want to be able to see purchases made after an event and compare them to purchases made after another event. The details and EventSample.qvw are above...thank you!!!
I looked at your new expression calculation and it does show the data with the multiple events selected, but where is it designating that it should only show if the OrderDate is within 90 days after the EventDate?
