topic Re: Set Analysis Product in QlikView

Set Analysis Product

Tue, 21 Jul 2015 02:50:06 GMT

Hi Guys,

Would like to know how to multiply fields in set analysis:

I know that for a sum of the field [Face_Amount] for records with [ScrubbingCode] = 'Included we have:

[1] SUM({<ScrubbingCode = {'Included'}>}[Face_Amount])

But say for example, I want to sum the product of the fields Exposure and Face_Amount where ScrubbingCode = 'Included'

How do I incorporate the [Exposure] field in the formula in [1] b/c the following formula does not work:

[2] SUM({<ScrubbingCode = {'Included'}>}[Face_Amount]*{<ScrubbingCode = {'Included'}>}[Exposure])

Thanks.

Joel

sunny_talwar — Tue, 21 Jul 2015 02:53:08 GMT

Try this:

=Sum({<ScrubbingCode = {'Included'}>} [Face_Amount]*[Exposure])

this expression will multiply Face Amount and Exposure and then sum it for each dimension.

=Sum({<ScrubbingCode = {'Included'}>}[Face_Amount])*Sum({<ScrubbingCode = {'Included'}>}[Exposure])

this expression will sum face amount and exposure for each dimension and then multiply.

HTH

Best,

Sunny

Tue, 21 Jul 2015 03:05:16 GMT

The first one worked!

Thanks sunindia!