Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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?

Labels (1)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand