Expression Probleme

Ayoub — Tue, 15 Dec 2020 10:49:35 GMT

Hello Community it's been a whiiiile ,

I'm facing a little problem Here, i hava table called Pack which have 3 Fields : Code,Product, Price,

The Product can take Multiple Value : A,D,R,P,B,C,D,E,F,G,H,I

and I shoudl Dress A table Which can tell me Wish Formul is this Pack:

Form 1 : B

Form 2 : B+C+(D or E)

Form 3 : B+C+(D orE)+(F or G )

Form 4 : B+C+(D orE)+(H or I )

i'm dealing with this prob since yesterday and i couldn't get the result i wan't , If someone could Help !

Thank you Before 😄

Re: Expression Probleme

edwin — Tue, 15 Dec 2020 20:06:55 GMT

try this for form 4:

=count({ <Prod=p({<Value={'B'}>}Prod)>* <Prod=p({<Value={'C'}>}Prod)>* <Prod=p({<Value={'D','E'}>}Prod)>* <Prod=p({<Value={'H','I'}>}Prod)> } Prod)

so its just a matter of combining AND statements. see attached. if there are heirarchies to your rule, you can create IF statements based on the 4 expressions

topic Re: Expression Probleme in QlikView

Expression Probleme

Re: Expression Probleme