topic Re: Set Analysis in QlikView

Set Analysis

gayathridevi24 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Set Analysis

Frank_Hartmann — Mon, 10 Sep 2018 08:13:13 GMT

Maybe this:

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

Re: Set Analysis

tresB — Mon, 10 Sep 2018 08:26:34 GMT

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.

Re: Set Analysis

Frank_Hartmann — Mon, 10 Sep 2018 09:31:37 GMT

I think Terescos solution is much better than mine 🙂

Re: Set Analysis

gayathridevi24 — Mon, 10 Sep 2018 09:34:42 GMT

Thank you so much Frank

Re: Set Analysis

Frank_Hartmann — Mon, 10 Sep 2018 09:36:57 GMT

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!

Re: Set Analysis

gayathridevi24 — Mon, 10 Sep 2018 09:37:16 GMT

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