topic Show only new customers in QlikView

Show only new customers

Thu, 10 Dec 2015 13:54:14 GMT

I have a table with customers revenue with expresions that calculate the revenue per year.

Customer	2015	2014	2013
A	110	100	100
B	120	0	0
C	130	90	80
D	90	100	100
E	80	100	100
F	70	0	0
G	120	0	0
H	105	100	100
I	105	100	100
J	105	100	100

I now wan to show only the new customers, so the customers that have no revenue in 2014 and 2013.

Customer	2015	2014	2013
B	120	0	0
F	70	0	0
G	120	0	0

Can anyone assist?

Re: Show only new customers

sunny_talwar — Thu, 10 Dec 2015 18:13:06 GMT

Do you have 2014 and 2013 as a separate column in your database or is this just how your data is laid out in a pivot table with year dimension pivoted?

Re: Show only new customers

Thu, 10 Dec 2015 18:16:41 GMT

The data is laid out in a pivot table with the year dimension pivoted.

The base table is a table witl all sales records that contains an invoice date.

Re: Show only new customers

sunny_talwar — Thu, 10 Dec 2015 18:31:42 GMT

Try this:

=Only({<Customer = e({<Customer = {"=Sum({<Year = {2014, 2013}>}Data) > 0"}>})>}Data)