topic Aggr with Unit Numer in QlikView

Aggr with Unit Numer

Mon, 17 Nov 2014 15:02:52 GMT

Hi All,

I have a requirement :

i have four fields:

1. Unit Numbers

2. WeekDays

3. PeriodNumber

4. WeekNumber

5. Sales

Some Unit Numbers are having only 6 days data not all 7 days.

so i have to findout the unit numbers where the weekdays is less than 7, means not all 7 days present for particular unit.

i can find that in table using unitnumber as dimension & count(distinct week_day)<7 in expression. but i want the same in textbox.

i tried with aggr() but not got solution. If anybody have any clue.

Pls share asap.

Thanks..!!!

Peter_Cammaert — Mon, 17 Nov 2014 15:24:19 GMT

What do you want to put in this text box? A long list of comma-separated Unit numbers? Then use:

=Concat(aggr(...))

Gysbert_Wassenaar — Mon, 17 Nov 2014 15:31:35 GMT

Perhaps like this: =concat({<[Unit Numbers = {'=count(distinct Weekdays)<7'} ]>} distinct [Unit Numbers], ', ')