Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Specialist III
Specialist III

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