Set analysis ignore dimension

Thu, 28 Nov 2013 07:07:24 GMT

Here is the Case:

Customer participated in Sales events and make purchase. The management want a report to show how each event, each customer is doing compare to the last time.

In the load script I will generate "prev_Event_Date" And "prev_Event_ID" for each of the purchase. So the report for customer level is easy to do....The problem comes when I try to generate the report on event level. In general, I need to show the number of customer comparing selected and previous run. I create a report which have 2 dimension Event Id and Event Type, I use = Max(Pre_Event_Date) as Last event Date, and base on the Last event Date I can find the Last event ID. but I cannot count the number for customer in the Last event because the Event Id is in the dimension.

Anyone have any idea how we can Ignore the dimension and count({<Event_ID = Pre_Event_ID >} Distinct Customer ID)??

Re: Set analysis ignore dimension

Anonymous — Fri, 29 Nov 2013 10:13:21 GMT

i suggest, if you can post a sample qvw. then it will be better to understand the dataset and work towards a solution to your problem.

topic Set analysis ignore dimension in QlikView

Set analysis ignore dimension

Re: Set analysis ignore dimension