Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor II

Multiple Restraints on a Set Expression

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

Labels (1)
3 Replies

Re: Multiple Restraints on a Set Expression

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 

New Contributor II

Re: Multiple Restraints on a Set Expression

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

Can you share the exact expression you have used?