Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

try this for form 4:


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