topic Formula problem - Set analysis in another set analysis in QlikView

Formula problem - Set analysis in another set analysis

Thu, 01 Jul 2010 15:20:38 GMT

I have the following formula to calculate my total volumes:

(sum({$<MaterialTypeCode = {$(='FERT')}>} (Volume))) - this then adds up the volume of a certain product.

The I have a Previous Year Calculation:

(sum({$<Year = {$(=only(Year) - 1)}>} (Volume))) - this adds up all the volumes of all the products for last year.

How do I merge the top formula with the bottow one so that I can get the previous year volumes of that specific product?

This would basically be a set analysis in another set analysis. Is that possible?

Thu, 01 Jul 2010 15:43:21 GMT

Hi Christo

Try this:

(sum({$<MaterialTypeCode = {$(='FERT')}, Year = {$(=only(Year) - 1)}>} (Volume)))

i.e., between the <> you can separate different selections using a comma.

Fri, 02 Jul 2010 07:40:04 GMT

Thank you This works great.