topic Re: Where Clause in Set Analysis in QlikView

Where Clause in Set Analysis

Wed, 11 Jun 2014 12:48:46 GMT

Hi everyone, is it possible to write something like that in a formula (set analysis)?

=Sum ([QTA 1 Documento]), where [Documento] in 'INT-BUONOCAR','INT-BUONOSCA'

please do not suggest me to use the where clause in Load, because I cannot do it...I need to find a way to use it in the set analysis...

Thanks to anyone, who will try to answer me!

Re: Where Clause in Set Analysis

Wed, 11 Jun 2014 12:52:34 GMT

You can't use where within set analysis. However:

=Sum({<Documento = {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])

Should work.

{<Document = {'INT-BUONOCAR','INT-BUONOSCA'}>} this expression tells the sum function to only documents that have the name INT_BUONOCAR and INT-BUONOSCA

Re: Where Clause in Set Analysis

ashfaq_haseeb — Wed, 11 Jun 2014 12:53:55 GMT

may be like this

Sum ({< [Documento]={'INT-BUONOCAR','INT-BUONOSCA'}>}[QTA 1 Documento])

Regards

ASHFAQ

Re: Where Clause in Set Analysis

Wed, 11 Jun 2014 13:04:14 GMT

=Sum({<[Codice Documento]= {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])

it doesn't work...it doesn't select those specific values...

any other suggestion?

Re: Where Clause in Set Analysis

Wed, 11 Jun 2014 13:06:01 GMT

Could you share your qvw? Not sure why it wouldnt work.

Re: Where Clause in Set Analysis

ashfaq_haseeb — Wed, 11 Jun 2014 13:06:05 GMT

Hi you are using

Sum({<[Codice Documento]= {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])

use this intead

=Sum({<Documento = {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])

or post a sample app.

Regards

ASHFAQ

Re: Where Clause in Set Analysis

Wed, 11 Jun 2014 13:08:14 GMT

Yes, make sure you are using the exact field names from your qvw or it will not work.

Re: Where Clause in Set Analysis

Wed, 11 Jun 2014 13:14:32 GMT

Try this

=Sum({<[Codice Documento]= {"INT-BUONOCAR","INT-BUONOSCA"}>} [QTA 1 Documento])

Thanks & Regards

Milind

Re: Where Clause in Set Analysis

Wed, 11 Jun 2014 13:15:59 GMT

Could you provide some more info about INT-BUONOCAR and INT-BUONOSCA?

Are these field values in your data model or are they variables you made in your document?

Re: Re: Where Clause in Set Analysis

Wed, 11 Jun 2014 13:17:28 GMT

this is the original file...

and yes, the name was correct in the formula

Re: Re: Where Clause in Set Analysis

Wed, 11 Jun 2014 13:19:47 GMT

they are field values for the Codice Documento variable

Re: Where Clause in Set Analysis

MayilVahanan — Wed, 11 Jun 2014 13:20:01 GMT

Try like this

=Sum ({<[Documento] = {'INT-BUONOCAR','INT-BUONOSCA'}>}[QTA 1 Documento])

Re: Where Clause in Set Analysis

Anonymous — Wed, 11 Jun 2014 13:22:55 GMT

if they are field values then this should work

=Sum({<[Codice Documento] = {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])

Re: Re: Where Clause in Set Analysis

Wed, 11 Jun 2014 13:22:58 GMT

If Codice Documento is a variable:

if([Codice Documento] = 'INT-BUONOCAR' or [Codice Documento] = 'INT-BUONOSCA', sum(QTA 1 Documento))

If Codice Documento is a field in your data model:

sum({<[Codice Document] = {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])

Re: Where Clause in Set Analysis

ashfaq_haseeb — Wed, 11 Jun 2014 13:27:09 GMT

Hi you get correct result.

however your field INT-BUONOSCA is not conneced with date.

may be need to check the model.

Regards

ASHFAQ