topic Re: Aggregation function in QlikView

Aggregation function

tamilarasu — Mon, 02 Mar 2015 02:55:08 GMT

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 — Mon, 02 Mar 2015 03:04:18 GMT

Load

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

Resident Data

Group By S.Person,Cust;

tamilarasu — Mon, 02 Mar 2015 03:32:31 GMT

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 — Mon, 02 Mar 2015 07:06:28 GMT

Dim: S.Person,Cust

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

tamilarasu — Mon, 02 Mar 2015 08:38:05 GMT

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 — Mon, 02 Mar 2015 08:49:45 GMT

Isn't Sum() aggregration function?

tamilarasu — Mon, 02 Mar 2015 09:12:18 GMT

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 — Mon, 02 Mar 2015 12:44:45 GMT

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 — Tue, 03 Mar 2015 05:27:14 GMT

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