topic Re: Re: Set Analysis- Multiple Conditions in QlikView

Set Analysis- Multiple Conditions

Mon, 21 Oct 2013 07:05:15 GMT

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!

Re: Set Analysis- Multiple Conditions

Mon, 21 Oct 2013 07:16:50 GMT

Try all the RZZLOKKT values quoted with single quote or double quote

Re: Set Analysis- Multiple Conditions

Mon, 21 Oct 2013 07:31:32 GMT

Maeby you need to add the = symbol inside modifier RYEAR ? This is if Anul contains a function..

RYEAR = {$(=Anul)}

Re: Set Analysis- Multiple Conditions

tresB — Mon, 21 Oct 2013 07:33:15 GMT

I guess the issue might lie in 'RYEAR = {$(Anul)}'. If 'Anul' is a variable, try like:

RYEAR = {"=$(=Anul)"}

Re: Set Analysis- Multiple Conditions

er_mohit — Mon, 21 Oct 2013 07:48:06 GMT

Try this

RYEAR = {'$(Anul)'}

Re: Set Analysis- Multiple Conditions

Mon, 21 Oct 2013 12:17:50 GMT

Thank you, guys! Sorry! I don't know why but it's not working ( And I've tried all your solutions.

Re: Set Analysis- Multiple Conditions

tresB — Mon, 21 Oct 2013 12:28:38 GMT

Could you share sample app?

Re: Set Analysis- Multiple Conditions

fabio_vallone — Mon, 21 Oct 2013 12:37:40 GMT

Try to create a flag into LOAD script (IF Statement), so use:

SUM ({<RZZLOKKT = {'Y'}, RBUSA ={'BOO'}, RBUKRS={'ASIN'}, RYEAR = {'=$(Anul)'} >} HSL123)

Re: Set Analysis- Multiple Conditions

rajni_batra — Mon, 21 Oct 2013 12:41:41 GMT

TRY:

SUM ({<RZZLOKKT ={'5001106470','5099001000','5099004000','5099006000','5099014000','50990'50000','5099053000','5099054000','509905'5000','5099056000','5099057000','5099058000','5099059000',

'5099060000','5099102000','5099110000','5099111000','5099149000','50991'50000','5099151000','5099153000','5099154000','5099157000','509952'5000','5099200000','5099201000',

'5099203000','5099210000','5099211000','5099212000','5099213000','5099214000','509921'5000','5099251000','5099252000','5099253000','5099254000','5099269000','5099288000',

'509939'5000','5099536000','5099301000','5099302000','5099304000','509930'5000','5099311000','5099312000','5099313000','5099314000','5099318000','5099343000','5099349000',

'5099356000','5099409000','5099351000','5099220000','50993'50000','509935'5000','5099360000','5099398000','509945'5000','5099354000','5099364000','5099380000','5099382000',

'5099383000','5099384000','5099386000','5099399000','509940'5000','5099449000','5099352000','5099391000','5099392000','5099410000','509900'5000','5099367000','5099422000',

'50994'50000','5099451000','5099452000','5099453000','5099454000','5099492000','5099361000','5099402000','5099522000','5099523000','5099529000','5099368000','5099420000',

'509944'5000','5001106400','5099001000','5099004000','5099006000','5099014000','509901'5000','50990'50000','5099053000','5099054000','509905'5000','5099056000','5099057000',

'5099058000','5099059000','5099060000','5099102000','5099110000','5099111000','5099149000','50991'50000','5099151000','5099153000','5099154000','5099157000','509952'5000',

'5099200000','5099201000','5099203000','5099210000','5099211000','5099212000','5099213000','5099214000','509921'5000','5099251000','5099252000','5099253000','5099254000',

'5099269000','5099288000','509939'5000','5099536000','5099301000','5099302000','5099304000','509930'5000','5099311000','5099312000','5099313000','5099314000','5099318000',

'5099343000','5099349000','5099356000','5099409000','5099351000','5099220000','50993'50000','509935'5000','5099360000','5099398000','509945'5000','5099354000','5099364000',

'5099380000','5099382000','5099382100','5099383000','5099384000','5099386000','5099399000','509940'5000','5099449000','5099352000','5099391000','5099392000','5099410000',

'509900'5000','5099367000','5099422000','50994'50000','5099451000','5099452000','5099453000','5099454000','5099492000','5099361000','5099402000','5099522000','5099523000',

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

or post sample app..

Regards,

Re: Set Analysis- Multiple Conditions

Mon, 21 Oct 2013 17:07:15 GMT

Hi, try this!!

What are you doing in your variable, in my example just select a year

the examples of set analisys is on the text object

i shared the example !!

Regards.

Re: Set Analysis- Multiple Conditions

Tue, 22 Oct 2013 06:56:06 GMT

Good morning!

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

Thank you!

Regards!

Re: Re: Set Analysis- Multiple Conditions

tresB — Tue, 22 Oct 2013 07:21:46 GMT

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.

Re: Set Analysis- Multiple Conditions

Tue, 22 Oct 2013 11:39:44 GMT

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

Best Regards!