topic Re: Aggr function used for dimension in QlikView

Aggr function used for dimension

Thu, 21 May 2015 18:37:30 GMT

I am using an aggr function for an item dimension. It basically checks to see if the qty shipped (NO_UNITS) is not equal to zero, because I only want to see items that meet this criteria.

Well I have another criteria I need to add to this & I'm not sure how I would write this out.

I also need to not have any items that begin with the letter 'B' to be included in the set.

Is it possible to do this?????

Here's the function that I have so far:

=aggr(if(sum({<FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}>}(NO_UNITS))<>0, ITEM),ITEM)

Re: Aggr function used for dimension

Gysbert_Wassenaar — Thu, 21 May 2015 18:53:41 GMT

Try: =aggr(if(sum({<ITEM={'B*'},FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}>}(NO_UNITS))<>0, ITEM),ITEM)

Re: Aggr function used for dimension

Thu, 21 May 2015 18:58:05 GMT

This gives me all the items that begin with 'B' and I need items not beginning with 'B' and qty shipped <> 0

If I do <> I don't get any items to display

Re: Aggr function used for dimension

sunny_talwar — Thu, 21 May 2015 19:00:20 GMT

Then try this:

=aggr(if(sum({<ITEM -= {'B*'},FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}>}(NO_UNITS))<>0, ITEM),ITEM)