topic Function First... in QlikView

Function First...

Tue, 21 Jul 2009 20:35:47 GMT

Hi all,

I have two problems with Pivot Table:

in the sample attached (with your help some days ago), there rae 2 tables:

1 - In Tab.1 I want to show only first 3 observations for every year with more sales.

2 - In Tab.2, when I open the QLV document, I want to show only the first Dept. The name of the dept. in the text object, and than change dept with the list near.

Thank All

Function First...

Tue, 21 Jul 2009 21:45:36 GMT

Hi,

use a dynamic dimension like:

=Aggr(If(Rank(Sum(Sales)) <=3, Dept, 'Others'), Dept)

One step forward.

Rainer

Function First...

Tue, 21 Jul 2009 23:00:58 GMT

Thank Rainer,

and if I want to sort the Pivot Table by Year and by descending Sum(Sales) (of Dept.).

Thank 1000