How to exclude some records within a list

Anonymous — Tue, 19 May 2015 18:32:31 GMT

Hi,

I have a quite difficult problem...

I have a list of customers with the employees that supported them during two years (2013- 2014), and a certain measure (Amount).

In the first straight table I want to display customers that have some amounts for 2014 as dimension, showing as expressions the amount for 2014 and for (-> no problem!).

In the second straight table I want to display the employees (as dimension) bound to the customers described above (customer with amount for 2014), with their amounts for the two years (-> no problem for 2014, many problems for 2013!.

So, I have to exclude from employees list the ones which have in 2013 just customers with no amount in 2014; furthermore I have to exclude, for every employee, the amounts of 2013 related to customers with no amount in 2014.

Please, find data and the application attached with more details.

Thanks a lot,

Elena

Re: How to exclude some records within a list

Tue, 19 May 2015 18:39:57 GMT

Does something like this do the trick?

=sum({<CUSTOMER = P({<YEAR={"$(=(max(YEAR)))"}>}),YEAR={"$(=(max(YEAR)-1))"}>}AMOUNT)

Re: How to exclude some records within a list

ramoncova06 — Tue, 19 May 2015 21:25:35 GMT

see if this helps

Re: How to exclude some records within a list

Anonymous — Wed, 20 May 2015 14:18:00 GMT

Thank you very much!

It's perfect

Elena

topic Re: How to exclude some records within a list in QlikView

How to exclude some records within a list

Re: How to exclude some records within a list

Re: How to exclude some records within a list

Re: How to exclude some records within a list