topic Re: Usage of Aggregation in QlikView

Usage of Aggregation

Mon, 12 Nov 2012 15:26:36 GMT

Hi,

I have below mention expression and I want to convert to aggregation expression, reason behind converting into aggregration expression because I have multiple dimention and in each dimention I want total but with below mention expression it is limted to only VOUCHERNO.

I have below mention dimention on my piovt chart :

BRANCH_CODE,

YEAR,

QUARTER,

MONTH,

ITEMTYPE,

VOCHERDATE ,

VOCHERNO,

STOCKCATEGORY,

STOCKCODE

-------------------------------------------------------------------------

(

(sum(DISCOUNTCC))

(

(sum(SALESPRICE))

(sum(TOTAL<VOCHERNO>SALESPRICE))

*100

)

/100

)

--------------------------------------------------------------------------

I had tried to below mention expression but i did not get any result but not sure why

-------------------------------------------------------------------------

aggr(

(sum(DISCOUNTCC))

(

(sum(SALESPRICE))

(sum(TOTAL<VOCHERNO>SALESPRICE))

*100

)

/100

,BRANCH_CODE,YEAR,QUARTER,MONTH,ITEMTYPE,VOCHERDATE,VOCHERNO,STOCKCATEGORY,STOCKCODE

)

--------------------------------------------------------------------------

So any idea why ?

Re: Usage of Aggregation

Wed, 14 Nov 2012 09:34:37 GMT

Is anyone ready to help me on my question ?

Re: Usage of Aggregation

Jason_Michaelides — Wed, 14 Nov 2012 09:51:20 GMT

Can you provide a sample? And clearly describe the output you require.

Re: Usage of Aggregation

jagan — Wed, 14 Nov 2012 13:22:48 GMT

Hi,

Try this expression

Sum(

aggr(

(sum(DISCOUNTCC))

(

(sum(SALESPRICE))

(sum(TOTAL<VOCHERNO>SALESPRICE))

*100

)

/100

,BRANCH_CODE,YEAR,QUARTER,MONTH,ITEMTYPE,VOCHERDATE,VOCHERNO,STOCKCATEGORY,STOCKCODE

))

Hope this helps you.

Regards,

Jagan.

Re: Usage of Aggregation

Thu, 15 Nov 2012 05:23:45 GMT

Thanks Jagan mohan,

it is all most same answer I am looking for.

After trying above mention expression I had found that when I am exploring and reaching to individual item calculation is correct but when I am closing one by one dimension total is getting reduce.

I will prepare example from real data and post here so you guys and understand the issue.

Appreciate your time and cooperation.

Re: Usage of Aggregation

Thu, 15 Nov 2012 05:25:25 GMT

I had post reply on jagan post and sure I will prepare sameple data from real data and post here.

Thanks.

Re: Usage of Aggregation

jagan — Thu, 15 Nov 2012 07:57:20 GMT

Hi,

Try this expression

Sum( TOTAL <BRANCH_CODE,YEAR,QUARTER,MONTH,ITEMTYPE,VOCHERDATE,VOCHERNO,STOCKCATEGORY,STOCKCODE>

(sum(DISCOUNTCC))

(

(sum(SALESPRICE))

(sum(TOTAL<VOCHERNO>SALESPRICE))

*100

)

/100)

Hope this helps you.

Regards,

Jagan.