topic Re: Aggregation in QlikView

Aggregation

johnso2080 — Wed, 01 May 2013 11:21:57 GMT

Hello,

I'm trying to get a count of how many product variants are out of stock on a given week.

However, I only want to include variants that belong to a product that DOES have stock (in other variants) in the same week...

An example table would be..

I would expect the results to be..

Hope this makes sense. Any advice would be much appreciated!

Thanks

Darren

Wed, 01 May 2013 11:32:56 GMT

DIMENSION--

week

=IF(product='A' OR product='C' OR product='E',product)

stock

NOTE-- SELECT THE SECOND DIMENSION AND CHECK ON SUPRESS NULL VALUE

EXPRESSION--

if(stock=0, count(varient))

then output like this

SEE ATTACHEMENT

johnso2080 — Wed, 01 May 2013 12:08:47 GMT

Hello,

This will only give me the count of variants each week.

What I need is the count of variants that have 0 stock, but belong to a product that DOES have stock (in other variants)...

Hope this is clear

Thank you!

er_mohit — Wed, 01 May 2013 12:38:45 GMT

try this

Aggr(count({$<Stock={'0'}>}Variant),Product)

or this

Aggr(Count( {$<Stock = E({$<Stock={'0'}>})>}Product),Product)

johnso2080 — Wed, 01 May 2013 13:26:10 GMT

Thanks for your help.

It's getting close, but not quite worked how I wanted. I've attached the example. It gives me 2 in week 1, but this should be 3...? Any ideas..?

Thanks

Darren