Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

leni_balakrishn
Contributor III

Set Analysis

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

Tags (1)
1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Re: Re: Set Analysis

have a look

this example work perfectly

16 Replies
sasikanth
Valued Contributor III

Re: Set Analysis

hi

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

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

lironbaram
Honored Contributor II

Re: Set Analysis

hi

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

leni_balakrishn
Contributor III

Re: Set Analysis

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??

MVP
MVP

Re: Set Analysis

Re: Set Analysis

Hi try below

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


Regards

ASHFAQ

Re: Set Analysis

Hi try below

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


Regards

ASHFAQ

leni_balakrishn
Contributor III

Re: Set Analysis

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

Re: Set Analysis

Hi,

Can you post your sample app.

Regards

ASHFAQ

leni_balakrishn
Contributor III

Re: Set Analysis

Not working