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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
MK_QSL
MVP
MVP

Set Analysis

What’s wrong this set analysis

  =sum({$<[Country]={'Germany','United Kingdom, 'France'}>}$(vTotalSale))

12 Replies
MK_QSL
MVP
MVP
Author

excel and qvw both enclosed.

AbhijitBansode
Specialist
Specialist

Change the value of variable to:

if( CURRENCY='eur',  QTY*PRICE,  QTY*PRICE*[EX RATE]  )

and use the set expression that you have already written on Text Object of your qvw file.

MK_QSL
MVP
MVP
Author

Ohh.... realized my mistake.... Thanks for your help.