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

16 Replies
Anonymous
Not applicable
Author

Hi,

Please find the attachment

Thanks,

Leni

Anonymous
Not applicable
Author

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.

Not applicable
Author

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

lironbaram
Partner - Master III
Partner - Master III

have a look

this example work perfectly

israrkhan
Specialist II
Specialist II

Hi Leni,

Find the attachment, its working.

and expression is,

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

Regards

Khan

Anonymous
Not applicable
Author

Thank you Khan It is working

Anonymous
Not applicable
Author

Thank you for the solution It worked