topic Re: Problem with set analysis in QlikView

Problem with set analysis

ecabanas — Mon, 09 Nov 2015 15:50:10 GMT

Hi Guys,

I wnat to create a table with the following formula:

- I want to show the customers that did not buy in the selected month and bought in the previously (Lost). In the file attache if you select April the RED table has to show the following records in red: C000005, C000006 and C000008

CustomerID	Date	Salesid
C000001	31/01/2015	A
C000002	31/01/2015	B
C000003	31/01/2015	C
C000004	31/01/2015	D
C000001	28/02/2015	E
C000002	28/02/2015	F
C000005	28/02/2015	G
C000006	28/02/2015	H
C000005	31/03/2015	I
C000006	31/03/2015	J
C000007	31/03/2015	K
C000008	31/03/2015	L
C000007	30/04/2015	K
C000009	30/04/2015	M

Many thank's guys

Eduard

Re: Problem with set analysis

rubenmarin — Mon, 09 Nov 2015 16:01:09 GMT

Hi Eduard, the selection in month is messing with your expression, ignore selections in months:

count({<MonthIndex={'$(VPriorMonth)'},CustomerID=E({<MonthIndex={'$(VCurrentMonth)'}>}CustomerID), CalendarMonthName>} distinct CustomerID)

Re: Problem with set analysis

ecabanas — Mon, 09 Nov 2015 16:03:01 GMT

Many thank's Ruben