Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: 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