Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

have a look

this example work perfectly

View solution in original post

16 Replies
sasikanth
Master
Master

hi

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

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

lironbaram
Partner - Master III
Partner - Master III

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

Anonymous
Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

Hi try below

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


Regards

ASHFAQ

ashfaq_haseeb
Champion III
Champion III

Hi try below

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


Regards

ASHFAQ

Anonymous
Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

Hi,

Can you post your sample app.

Regards

ASHFAQ

Anonymous
Not applicable
Author

Not working