Using lowest selected value in set analysis

Sun, 08 Dec 2013 20:27:10 GMT

I have the following data and wish to know how many workers start work on the first week of any selection. With no selection, therefore only one person starts work on the first week (that is Worker JS on 200313),

I wish to build a table of who manages those starters. I have a straight table with the manager dimension and the expression count(distinct {$<YearWeek = {"=min(YearWeek)"}>} Worker) This gives me 1 for Bill and 2 for Dave. I therefore explored the AGGR function and used count(distinct {$<YearWeek = {"=aggr(min(YearWeek),Manager)"}>} Worker) but with the same results.

Can anyone help on this. In essence I need to use the lowest selected value in set analysis regardless of Dimension

Thanks

Dave

Manager	Worker	YearWeek
Bill	IK	200316
Bill	IK	200317
Bill	IK	200318
Dave	DS	200315
Dave	DS	200316
Dave	DS	200317
Dave	DS	200318
Dave	DS	200319
Dave	DS	200320
Dave	JS	200313
Dave	JS	200314
Dave	JS	200315
Dave	JS	200316
Dave	JS	200317
Dave	JS	200318
Dave	JS	200319

Re: Using lowest selected value in set analysis

swuehl — Sun, 08 Dec 2013 20:45:59 GMT

Try a set expression using a dollar sign expansion in your set modifier:

=count(distinct {$<YearWeek = {$(=min(YearWeek))}>} Worker)

Re: Using lowest selected value in set analysis

Mon, 09 Dec 2013 08:29:56 GMT

Thank you swuehi for super fast response. That worked a treat

topic Using lowest selected value in set analysis in QlikView

Using lowest selected value in set analysis

Re: Using lowest selected value in set analysis

Re: Using lowest selected value in set analysis