Aggregation function

[tamilarasu]

Hi,

I am new to qlikview. Can any one suggest me a aggregation function for the below case.

Attached sample file.

Thanks in advance.

Regards,

Tamil

[anbu1984]

Load

    S.Person,Cust,Sum(If([Old Price]=[New Price],1)) As PrdHaveSamePrce

Resident Data

Group By S.Person,Cust;

[tamilarasu]

HI Anbu,

This is sample one. I would like to do this in expression, since the data mode is already created. Can you suggest me an expression?

[anbu1984]

Dim: S.Person,Cust

Expr: Sum(If([Old Price]=[New Price],1))

[tamilarasu]

Thank you Anbu Chelian. I am curious to know whether it is possible to get the same result through aggregation function. Kindly let me know.

[anbu1984]

Isn't Sum() aggregration function?

[tamilarasu]

The below expression is working fine, if i add product in dimensions. But its not working if i want to know Sales person wise summary.

=Count(Aggr(Count(if([Old Price]=[New Price],Cust)),

S.Person))

Can you tel me where it is wrong?

[anbu1984 · Accepted solution]

Is the above expr gives correct result with Dim: S.Person, Cust ?

You can use the below

Dim: S.Person, Cust

Expr: Count(if([Old Price]=[New Price],Cust))

[tamilarasu]

Sorry the expression which I mentioned is not working. Anyways your solution is working fine. Thank you so much.