Set Analysis with multiple parameters

[milindnikumbh]

Dear Experts ,

Greetings !

I am not able to resolve set analysis using variable with multiple conditions.

=( Sum (
{ <CYEAR={$(=Var2)},
  PARAMETERS = {'TOTAL PRODUCTION'}
  > } DIFFERENCE
 
)
) < 90

+

( Sum (
{ <CYEAR={$(=Var2)},
  PARAMETERS = {'OVER ALL EQPT EFFECTIVENESS'}
  >} DIFFERENCE
 
)
) < 90

Following is working fine without PARAMETER condition..

=Sum({$<CYEAR={$(=Var2)} > } DIFFERENCE ) < 90

Please help ..

Regards,

Milind.

[Anil_Babu_Samineni]

QlikView is Case Sensitive, You should have written all correct values. Like

PARAMETERS

OVER ALL EQPT effectiveness

And You triend it as OVER ALL EQPT EFFECTIVENESS .. This won't work dues to Upper Case..

[milindnikumbh · Accepted solution]

Thanks Anil. We have resolve by using if statement ..

= ( if(PARAMETERS = 'TOTAL PRODUCTION' , ( Sum (
{ <CYEAR={$(=Var2)}
  > } DIFFERENCE
 
)
) < 90 ,0)

)
or
(
if(PARAMETERS = 'OVER ALL EQPT EFFECTIVENESS' ,
( Sum (
{ <CYEAR={$(=Var2)}
  >} DIFFERENCE
 
)
) < 90 ,0)
)

[Anil_Babu_Samineni]

If you are looking as you writtenn? I would prefer to use this as more efficient

=Alt((Sum({<CYEAR={$(=Var2)}, PARAMETERS = {'TOTAL PRODUCTION'}>+<CYEAR={$(=Var2)},
  PARAMETERS = {'OVER ALL EQPT EFFECTIVENESS'}> } DIFFERENCE)) < 90, 0)