topic Re: Set Analysis problem in QlikView

Set Analysis problem

BootCam — Sat, 16 Nov 2024 02:28:26 GMT

Hi,

I would like to create a straight table based on the example data in the excel file. The condition is mentioned in the excel file. I need to calculate the sum of Amounts only for the red marked IDs and Type field.

Thanks,

Re: Set Analysis problem

Vegar — Tue, 17 Sep 2019 03:55:22 GMT

Can I rephrase your condition to this?

Calculate the sum amount but exclude all amount for the IDs that is associated with type B.

If so then try this expression.

Sum({<ID=E({<Type={'B'}>}) [Aumount($)])

Re: Set Analysis problem

BootCam — Tue, 17 Sep 2019 04:20:17 GMT

Thank you so much Vegar!

-BC

Re: Set Analysis problem

sugathirajkumar — Tue, 17 Sep 2019 08:59:36 GMT

Sum({<Type={'A'}>}[Amount($)])