Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Ayoub
Contributor III
Contributor III

Expression Probleme

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 😄

1 Reply
edwin
Master II
Master II

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