topic Pivot Table and dimension in QlikView

Pivot Table and dimension

filippo — Thu, 04 Feb 2010 16:03:06 GMT

Hi Community,

I have a problem with pivot table with 2 dimensions: Customer, Year

and 1 expression: SUM(NET)

I would like to see only the customers who have values in all the years.

How can i do?

Thanks

mike_garcia — Thu, 04 Feb 2010 16:24:09 GMT

Hi,

I have not tested this one, but it might do the trick.

sum( {$<Customer = {"=count(aggr(Sum(NET), Year)) = max(Year) - min(Year) + 1"}>} NET)

Let me know it it helps.

Mike