topic Re: Set Analysis in QlikView

Set Analysis

Anonymous — Mon, 16 Jun 2014 12:48:03 GMT

Hi All,

I have a question,

Is there a way we can disregard all selections except one. For Example, I have an application which has many fields so in that I want one of my chart to show data disregarding of all selections except the selection on currency.

Is there any way we could achieve using set analysis.?

Thanks,

Leni Balakrishnan

Re: Set Analysis

sasikanth — Mon, 16 Jun 2014 12:53:18 GMT

Why ddidnt you try to fire trigger , and make the condition like

if(getFiledSelections(<filedName>)='currency',1,0)

Re: Set Analysis

lironbaram — Mon, 16 Jun 2014 12:53:58 GMT

yes you can

it should looks something like

sum({1<Currency=Currency>}Sales)

so the 1 signals to disregard all selections , and the currency=currency implies the currency values

Re: Set Analysis

Anonymous — Mon, 16 Jun 2014 12:56:30 GMT

Thank you

But this is something like I have an expression and the expression should return value disregarding of all selections in the application except on the currency field.

As my expression is something like amount*rate and the rate will be calculated based on the currency type selected.

So how it is possible to achieve using triggers??

Re: Set Analysis

tresB — Mon, 16 Jun 2014 12:57:09 GMT

See this blog post: Ignore all selections except some specific fields using Set Analysis

Re: Set Analysis

ashfaq_haseeb — Mon, 16 Jun 2014 13:03:03 GMT

Hi try below

sum({1<Currency=p(Currency)>}Sales)

Regards

ASHFAQ

Re: Set Analysis

ashfaq_haseeb — Mon, 16 Jun 2014 13:03:40 GMT

Hi try below

sum({1<Currency=p(Currency)>}Sales)

Regards

ASHFAQ

Re: Set Analysis

Anonymous — Mon, 16 Jun 2014 13:52:27 GMT

I tried but it is not working. Checked by selecting on different currency but still the value remains same

Re: Set Analysis

ashfaq_haseeb — Mon, 16 Jun 2014 13:54:52 GMT

Hi,

Can you post your sample app.

Regards

ASHFAQ

Re: Set Analysis

Anonymous — Mon, 16 Jun 2014 13:58:47 GMT

Not working

Re: Re: Set Analysis

Anonymous — Mon, 16 Jun 2014 14:14:22 GMT

Hi,

Please find the attachment

Thanks,

Leni

Re: Set Analysis

Anonymous — Mon, 16 Jun 2014 14:52:21 GMT

Hi,

Try something like this

Sum({<field1=,field2=,field3=,....fieldn=>}Sales)

Note :Write all the fields except currency field here as written above in the expression.

Re: Set Analysis

Mon, 16 Jun 2014 14:56:40 GMT

sum({1<Currency=p(Currency)>}Rate)*Amount

Re: Re: Set Analysis

lironbaram — Mon, 16 Jun 2014 14:59:20 GMT

have a look

this example work perfectly

Re: Set Analysis

israrkhan — Mon, 16 Jun 2014 16:02:16 GMT

Hi Leni,

Find the attachment, its working.

and expression is,

Sum({1<Currency = $::Currency>} Amount*Rate)

Regards

Khan

Re: Set Analysis

Anonymous — Tue, 17 Jun 2014 13:50:04 GMT

Thank you Khan It is working

Re: Set Analysis

Anonymous — Tue, 17 Jun 2014 13:52:16 GMT

Thank you for the solution It worked