topic Set analysis help in QlikView

Set analysis help

Tue, 07 Feb 2012 10:56:24 GMT

I wrote the set to calculate the amount as

sum({<Company={A},Branch={'X','Y','Z'}>}Amount)+sum({<Company={B},Branch={'X','W','A'}>}Amount)

the problem is when i select the company A, then the amount should show

only for the Company A, but here the value shows both A and B irrespective of the Company selections.

Could anyone help me.

thanks in advance.

CELAMBARASAN — Tue, 07 Feb 2012 11:00:47 GMT

Hi,

Use the expression with $

sum({$<Company={A},Branch={'X','Y','Z'}>}Amount)+sum({$<Company={B},Branch={'X','W','A'}>}Amount)

Hope it helps

Celambarasan

kuba_michalik — Tue, 07 Feb 2012 11:07:54 GMT

$ is entirely optional here.

Try this:

sum({<Company={A}*P(Company),Branch={'X','Y','Z'}>}Amount)+sum({<Company={B}*P(Company),Branch={'X','W','A'}>}Amount)

Be careful, though - if you select Company C (if there is one), nothing will get shown.

Tue, 07 Feb 2012 11:54:54 GMT

Thank you very much....