Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all - I'm trying to make a table which shows the result of a comparative analysis, but I don't know how to reference both alternate states of my field in question. What I would like to do is show the user's two selections in the field [Buyer] in one straight table object with a number of other fields, but QlikView is rejecting my expression. I thought it would have been something like;
=sum({<Buyer={AS1::Contractor,AS2::Contractor}>} Amounts)
Unfortunately, that doesn't work. Any help?
Try =sum({<Buyer=AS1::Contractor>+<Buyer=AS2::Contractor>} Amounts)