Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
alexpanjhc
Valued Contributor

set analysis with the reference columns

Hi

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!

Labels (2)
2 Replies
saminea_ANZ
New Contributor III

Re: set analysis with the reference columns

Perhaps this?

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

alexpanjhc
Valued Contributor

Re: set analysis with the reference columns

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