topic Re: Multiple Restraints on a Set Expression in QlikView

Multiple Restraints on a Set Expression

RafaelPerez — Sat, 16 Nov 2024 03:21:53 GMT

I'm trying to limit the information shown on a pivot table using the expressions. I want each expression to obey certain conditions. My question is: Do set expressions work like this

=sum({<Condition 1>*<Condition 2>*(<Condition 3.1>+<Condition 3.n>)*(<Condition 4.1>+<Condition 4.n>)} Fieldname)

I want the expression to fall under condition 1 and 2, any condition 3 and any condition 4.
I've tried this already but something's not working like I thought it would

Thanks in advance

Re: Multiple Restraints on a Set Expression

sunny_talwar — Fri, 07 Jun 2019 15:25:24 GMT

I believe this should work

=Sum({<Condition 1, Condition 2> * (<Condition 3.1>+<Condition 3.n>)*(<Condition 4.1>+<Condition 4.n>)}>} Fieldname)

Made two changes

1) Added Condition 1 and Condition 2 in one set

2) Added a ending >} before the Fieldname

Re: Multiple Restraints on a Set Expression

RafaelPerez — Fri, 07 Jun 2019 15:52:15 GMT

The first point worked fine, I didn't know you could do that. The second addition makes the system go "Error in expression"

Thanks for the quick reply!

Re: Multiple Restraints on a Set Expression

sunny_talwar — Fri, 07 Jun 2019 16:14:44 GMT

Can you share the exact expression you have used?