topic Re: Set Analysis in QlikView

Set Analysis

MK_QSL — Thu, 04 Jul 2013 09:47:43 GMT

What’s wrong this set analysis

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

Re: Set Analysis

sujeetsingh — Thu, 04 Jul 2013 09:50:48 GMT

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

See the red coclor says that one brachet is needed

Re: Set Analysis

sujeetsingh — Thu, 04 Jul 2013 09:54:59 GMT

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

Re: Set Analysis

Anonymous — Thu, 04 Jul 2013 09:59:32 GMT

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

use this analysis

And 'United Kingdom' semicolon is not there

Regards

Shivaji

Re: Set Analysis

MK_QSL — Thu, 04 Jul 2013 10:02:25 GMT

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

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

Here vTotalSale is varialble defines Invoice Total....

Re: Set Analysis

Anonymous — Thu, 04 Jul 2013 10:10:14 GMT

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

Re: Set Analysis

Anonymous — Thu, 04 Jul 2013 10:14:57 GMT

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

Regards

shivaji

Re: Set Analysis

MK_QSL — Thu, 04 Jul 2013 10:16:18 GMT

Not Working....

Re: Set Analysis

AbhijitBansode — Thu, 04 Jul 2013 10:17:54 GMT

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.

Re: Set Analysis

Sokkorn — Thu, 04 Jul 2013 10:29:05 GMT

Hi,

Can you share definition of vTotalSale here?

Regards,

Sokkorn

Re: Set Analysis

MK_QSL — Thu, 04 Jul 2013 10:45:06 GMT

excel and qvw both enclosed.

Re: Set Analysis

AbhijitBansode — Thu, 04 Jul 2013 10:56:53 GMT

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.

Re: Set Analysis

MK_QSL — Thu, 04 Jul 2013 11:00:01 GMT

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