Solved: Re: Set Analysis - Qlik Community

MK_QSL · ‎2013-07-04

What’s wrong this set analysis

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

AbhijitBansode · ‎2013-07-04

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.

sujeetsingh · ‎2013-07-04

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

See the red coclor says that one brachet is needed

sujeetsingh · ‎2013-07-04

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

Anonymous · ‎2013-07-04

Hi

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

use this analysis

And 'United Kingdom' semicolon is not there

Regards

Shivaji

MK_QSL · ‎2013-07-04

Thanks for your reply. But I am getting value 0...

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

Here vTotalSale is varialble defines Invoice Total....

Anonymous · ‎2013-07-04

=Sum({$<Country={$(=Germany)},Country={$(=France)},Country={$(=United Kingdom)}>}vTotalSales)

Anonymous · ‎2013-07-04

Hi

=Sum({$<Country={$(=Germany)},Country={$(=France)},Country={$(=United Kingdom)}>}$(vTotalSales))

Regards

shivaji

MK_QSL · ‎2013-07-04

Not Working....

AbhijitBansode · ‎2013-07-04

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

Above set expression should work, provided you have defined vTotalSale correctly.

Make sure that vTotalSale does not start with = sign in variable overive dialog box.

Sokkorn · ‎2013-07-04

Hi,

Can you share definition of vTotalSale here?

Regards,

Sokkorn

Set Analysis