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: 
gayathridevi24
Contributor III
Contributor III

Set Analysis

Hi All,

I am using set analysis in expression to function based on only one list box selection.

If am selecting any value in order total field, based on that only, value should changed. when I am using another filter it should not be changed. For me it is working as normal filter.

Can all please help to solve this issue.

I am using the expression as follows

=sum({1<[order id]=p([order id])>}[order total])

please find the attached qvw file.

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Maybe this:

=sum({<[customer name]>}[order total])

View solution in original post

6 Replies
Frank_Hartmann
Master II
Master II

Maybe this:

=sum({<[customer name]>}[order total])

tresesco
MVP
MVP

Try this:

=sum({1<[order id]=$::[order id]>}[order total])

You may read this: Ignore all selections except few fields using Set Analysis for better understanding.

Frank_Hartmann
Master II
Master II

I think Terescos solution is much better than mine 🙂

gayathridevi24
Contributor III
Contributor III
Author

Thank you so much Frank

Frank_Hartmann
Master II
Master II

I think you should consider Terescos solution as the correct one, Because if you have a lot of Filters his solution is neglecting them all except the one inside the setanalysis function!

gayathridevi24
Contributor III
Contributor III
Author

Thank you so much Tresesco. Very much useful for me.