Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis- Multiple Conditions

Hi guys,

I need a little bit of help, so I hope to get it from you.

I have a data table from SAP and I'm trying to define some expressions based on that table. I am using set analysis, but I don't know why is not working. I must say that I have a lot of conditions.

My expresion looks like this

SUM ({<RZZLOKKT ={5001106470,5099001000,5099004000,5099006000,5099014000,5099050000,5099053000,5099054000,5099055000,5099056000,5099057000,5099058000,5099059000,

5099060000,5099102000,5099110000,5099111000,5099149000,5099150000,5099151000,5099153000,5099154000,5099157000,5099525000,5099200000,5099201000,

5099203000,5099210000,5099211000,5099212000,5099213000,5099214000,5099215000,5099251000,5099252000,5099253000,5099254000,5099269000,5099288000,

5099395000,5099536000,5099301000,5099302000,5099304000,5099305000,5099311000,5099312000,5099313000,5099314000,5099318000,5099343000,5099349000,

5099356000,5099409000,5099351000,5099220000,5099350000,5099355000,5099360000,5099398000,5099455000,5099354000,5099364000,5099380000,5099382000,

5099383000,5099384000,5099386000,5099399000,5099405000,5099449000,5099352000,5099391000,5099392000,5099410000,5099005000,5099367000,5099422000,

5099450000,5099451000,5099452000,5099453000,5099454000,5099492000,5099361000,5099402000,5099522000,5099523000,5099529000,5099368000,5099420000,

5099445000,5001106400,5099001000,5099004000,5099006000,5099014000,5099015000,5099050000,5099053000,5099054000,5099055000,5099056000,5099057000,

5099058000,5099059000,5099060000,5099102000,5099110000,5099111000,5099149000,5099150000,5099151000,5099153000,5099154000,5099157000,5099525000,

5099200000,5099201000,5099203000,5099210000,5099211000,5099212000,5099213000,5099214000,5099215000,5099251000,5099252000,5099253000,5099254000,

5099269000,5099288000,5099395000,5099536000,5099301000,5099302000,5099304000,5099305000,5099311000,5099312000,5099313000,5099314000,5099318000,

5099343000,5099349000,5099356000,5099409000,5099351000,5099220000,5099350000,5099355000,5099360000,5099398000,5099455000,5099354000,5099364000,

5099380000,5099382000,5099382100,5099383000,5099384000,5099386000,5099399000,5099405000,5099449000,5099352000,5099391000,5099392000,5099410000,

5099005000,5099367000,5099422000,5099450000,5099451000,5099452000,5099453000,5099454000,5099492000,5099361000,5099402000,5099522000,5099523000,

5099529000,5099368000,5099420000,5099445000}, RBUSA ={'BOO'}, RBUKRS={'ASIN'}, RYEAR = {$(Anul)} >} HSL123)

I just can't realize where is my mistake. If I try to do the expresion with IF and OR it's working just for few records.

Thank you!

12 Replies
Not applicable
Author

Good morning!

Here's a sample of what I am trying to do. Hope that helps.

Thank you!

Regards!

tresesco
MVP
MVP

Couple of issues i noticed in your sample app:

-variable('Anul') definition was hard coded and value was derived - 2013, and there was no data for that year.

-you were summing HSL123, which should be HSL

-there was no data for those codes (RZZLOKKT) I added one(the first one) to test

Finally, with right data the expression should work as in attached sample.

Not applicable
Author

Thank you all very much! I finally saw where was the problem and solved it.

Best Regards!