topic Re: Error: Error in expression: Sum takes 1 parameter in QlikView

Error: Error in expression: Sum takes 1 parameter

agni_gold — Tue, 20 Sep 2016 16:21:58 GMT

Hi Friends ,

I am writing below expression

(If(Dimensionality()=1 or Dimensionality()=0,

sum({StateB<_GHQFlg=,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month>}$(vMetricBU_B_RM)),

sum({StateB<_GHQFlg=$::_GHQFlg,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month>}$(vMetricBU_B_RM))))

and variable has below expression

vMetricBU_B_RM:

=(If(Only({StateB}[KPI 22])='Total Volumes1','VOL___ORGANIC_GROWTH_RM','FIN___ORGANIC_GROWTH_RM'))

I am getting below error ,

Error: Error in expression: Sum takes 1 parameter

Please help to correct this.

Thanks

Re: Error: Error in expression: Sum takes 1 parameter

sunny_talwar — Tue, 20 Sep 2016 16:29:58 GMT

I think since you are using Only() function in your variable, you are basically using an aggregation within an aggregation. This might only work with a use of Aggr() function. Do you have a sample you can share with the expected output to help you better?

Re: Error: Error in expression: Sum takes 1 parameter

agni_gold — Tue, 20 Sep 2016 16:33:05 GMT

Sorry sunny , application is at client location but i have also tried with

=(If(MAx({StateB}[KPI 22])='Total Volumes1','VOL___ORGANIC_GROWTH_RM','FIN___ORGANIC_GROWTH_RM'))

but still is was showing same error ,

Re: Error: Error in expression: Sum takes 1 parameter

sunny_talwar — Tue, 20 Sep 2016 16:44:10 GMT

Max, Min, Sum, Avg, Only are all Aggregation functions and you cannot do

Sum(If(Max(.....)) or Sum(If(Only(...))

You need to do this

Sum(Aggr(If(Max(....)))

Does this make sense?

Re: Error: Error in expression: Sum takes 1 parameter

agni_gold — Tue, 20 Sep 2016 16:53:26 GMT

I have tried like this

=sum(If(Aggr(Max({StateB}[KPI 22]),[KPI 22])='Total Volumes1','VOL___ORGANIC_GROWTH_RM','FIN___ORGANIC_GROWTH_RM'))

it is giving 0

Re: Error: Error in expression: Sum takes 1 parameter

Digvijay_Singh — Tue, 20 Sep 2016 17:09:53 GMT

May be try this without variable -

=If(Dimensionality()=1 or Dimensionality()=0,

sum({StateB<_GHQFlg=,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month,[KPI 22]={'Total Volumes1'}>}VOL___ORGANIC_GROWTH_RM),

sum({StateB<_GHQFlg=$::_GHQFlg,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month,[KPI 22]={"[KPI 22]<>'Total Volumes1'"}>}FIN___ORGANIC_GROWTH_RM))

Re: Error: Error in expression: Sum takes 1 parameter

Anil_Babu_Samineni — Tue, 20 Sep 2016 17:15:16 GMT

Set analysis syntax should be sum({<>} sales)

But, in your expression

(If(Dimensionality()=1 or Dimensionality()=0,

sum({StateB<_GHQFlg=,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month>}$(vMetricBU_B_RM)),

sum({StateB<_GHQFlg=$::_GHQFlg,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month>}$(vMetricBU_B_RM))))

Can I know the reason why stateb indicates as current or all selections

Re: Error: Error in expression: Sum takes 1 parameter

agni_gold — Tue, 20 Sep 2016 17:16:00 GMT

Thanks ,

But in your first part

=If(Dimensionality()=1 or Dimensionality()=0,

sum({StateB<_GHQFlg=,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month,[KPI 22]={'Total Volumes1'}>}VOL___ORGANIC_GROWTH_RM),

sum({StateB<_GHQFlg=$::_GHQFlg,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month,[KPI 22]={"[KPI 22]<>'Total Volumes1'"}>}FIN___ORGANIC_GROWTH_RM))

You have retten only for VOL , but i need to change here also based on condition if KPI 22 is not total volumes1 then i need to used FIN___ORGANIC_GROWTH_RM

Re: Error: Error in expression: Sum takes 1 parameter

agni_gold — Tue, 20 Sep 2016 17:19:15 GMT

Thanks,

Yes it is written correctly i think , but expression pointing to StateB , that's why we have written like this , please provide any easy solution if you have

Re: Error: Error in expression: Sum takes 1 parameter

Digvijay_Singh — Tue, 20 Sep 2016 17:32:48 GMT

I agree with Sunny but the error message indicates that the variable expansion somehow creating two parameters to SUM function. Can you try '=' sign like $(=vMetricBU_B_RM), may be it will first calculate it before expansion.

Re: Error: Error in expression: Sum takes 1 parameter

agni_gold — Tue, 20 Sep 2016 17:39:00 GMT

No its not working

Re: Error: Error in expression: Sum takes 1 parameter

agni_gold — Tue, 20 Sep 2016 17:54:07 GMT

Friends,

Any help

Re: Error: Error in expression: Sum takes 1 parameter

Digvijay_Singh — Tue, 20 Sep 2016 17:56:47 GMT

last try, if this works -

sum({StateB<_GHQFlg=,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month}>}

if([KPI 22]='Total Volumes1',VOL___ORGANIC_GROWTH_RM,FIN___ORGANIC_GROWTH_RM)))

Re: Error: Error in expression: Sum takes 1 parameter

agni_gold — Tue, 20 Sep 2016 18:15:19 GMT

gwassenaar‌

Any help please .

Re: Error: Error in expression: Sum takes 1 parameter

agni_gold — Tue, 20 Sep 2016 18:15:46 GMT

Is any other way i can approach ?

Re: Error: Error in expression: Sum takes 1 parameter

Peter_Cammaert — Tue, 20 Sep 2016 18:24:44 GMT

The expression you are trying to create is pretty complex and your post is lacking many of the needed contextual details. To avoid turning this into a weeklong Q&A, can you post an example document with reduced data? Then we might figure out what you intend to do and how to best accomplish this. You know, the latter may be entirely different from what you posted so far.

Best,

Peter

Re: Error: Error in expression: Sum takes 1 parameter

agni_gold — Tue, 20 Sep 2016 19:33:42 GMT

=sum({StateB<_GHQFlg=,ACTUALITY_KEY={'AC'},VARIANCE_BASE_SK={'BU'}, Year=$::Year,Month=$::Month}>}

if([KPI 22]='Total Volumes1',VOL___ORGANIC_GROWTH_RM,FIN___ORGANIC_GROWTH_RM))

error line coming for bold