Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Aggr with Unit Numer

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.


2 Replies

Re: Aggr with Unit Numer

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


MVP & Luminary
MVP & Luminary

Re: Aggr with Unit Numer

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

talk is cheap, supply exceeds demand