topic Re: Set Analysis with multiple parameters in QlikView

Set Analysis with multiple parameters

milindnikumbh — Sat, 16 Dec 2017 10:17:19 GMT

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.

Re: Set Analysis with multiple parameters

Anil_Babu_Samineni — Sat, 16 Dec 2017 11:00:17 GMT

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..

Re: Set Analysis with multiple parameters

milindnikumbh — Sat, 16 Dec 2017 11:19:06 GMT

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)
)

Re: Set Analysis with multiple parameters

Anil_Babu_Samineni — Sat, 16 Dec 2017 11:29:54 GMT

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)