Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing two Alternate States in one table?

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?

1 Reply
Gysbert_Wassenaar

Try =sum({<Buyer=AS1::Contractor>+<Buyer=AS2::Contractor>} Amounts)


talk is cheap, supply exceeds demand