topic help needed -- set analysis question in QlikView

help needed -- set analysis question

Tue, 10 Apr 2012 22:12:41 GMT

Hi all,

Please consider the following example:

I want to get their sales figures in the 1^st year of their sales job. Therefore, results should be as the following:

What is the best way to get this working? I tried set analysis within sum(), aggr().. no luck

Thanks!

swuehl — Tue, 10 Apr 2012 22:38:11 GMT

I assume you won't have records for your SalesPerson prior their joining dates.

Then it should be enough to create a table with dimension SalesPerson and four expressions

=FirstSortedValue(Sales, Year,1)

=FirstSortedValue(Sales, Year,2)

=FirstSortedValue(Sales, Year,3)

=FirstSortedValue(Sales, Year,4)

Wed, 11 Apr 2012 01:08:22 GMT

Many thanks Stefan! Now I know one more useful function! Very easy actually.

Marko