topic Re: set analysis with the reference columns in QlikView

set analysis with the reference columns

alexpanjhc — Sat, 16 Nov 2024 21:01:36 GMT

I am trying to use a reference column in my set analysis and I am not sure how it works.

Sum({<STATUS={'OPEN'}, [Tax Unrealized]={"<0"}>}POSITION)

where Tax Unrealized is calculated by other fields let's say A-B-C.

I want to sum up the position by all the lines where A-B-C<0 and it is showing me everything including A-B-C>=0.

Where am I wrong?

thanks!

saminea_ANZ — Thu, 18 Apr 2019 02:03:09 GMT

Perhaps this?

Sum({<STATUS={'OPEN'}, [Tax Unrealized]={"<0"}, POSITION ={'A', 'B', 'C'}>}POSITION)

alexpanjhc — Thu, 18 Apr 2019 13:40:16 GMT

Thanks for your response but A, B, C are numbers. that does not seem to be right.