topic Re: Aggregate function in QlikView

Aggregate function

Anonymous — Wed, 01 Feb 2012 08:30:45 GMT

sum(ValueINR) is not working correctly in pivot table

sum(valueINR is 1000000

but it show 40000 its column wise

Aggregate function

kaushiknsolanki — Wed, 01 Feb 2012 08:33:47 GMT

HI,

Please explain in detail with what you are doing. If possible also attach the sample example (QVW file)

Regards,

Kaushik Solanki

Re: Aggregate function

Anonymous — Wed, 01 Feb 2012 08:46:57 GMT

ValueINR Region

500 south

1000 north

500 east

1500 south

200 north

700 east

700 west

this is Table Value

in pivot Table

Region

east 1200

west 700

north 1200

south 20000

but i want total value is 5100

Aggregate function

kaushiknsolanki — Wed, 01 Feb 2012 08:51:50 GMT

Hi,

So only thing is you need total in pivot table...?

If yes then go to properties -> Presentations -> Dimensions & expressions -> select region and then check show partial sum -> click apply and ok

Regards,

Kaushik Solanki

Re: Aggregate function

Wed, 01 Feb 2012 08:52:17 GMT

So you want to display for every region the total value for all regions?

Aggregate function

Anonymous — Wed, 01 Feb 2012 08:56:40 GMT

yes Przemek you are right

Aggregate function

Wed, 01 Feb 2012 09:00:09 GMT

You can use sum(total ValueINR)

Re: Aggregate function

Anonymous — Wed, 01 Feb 2012 09:09:47 GMT

hi Kaushik Solanki i want to calculate the percent of north region so i put formula in expression

sum(Value INR)/ sum(Value INR)/100 (ie for east region 1200/(5100/100))

Region Value INR percent

east 1200 23%

west 700 13%

north 1200 23 %

south 2000 39 %

Re: Aggregate function

CELAMBARASAN — Wed, 01 Feb 2012 09:13:25 GMT

Hi,

You can try with this expression,

(sum(ValueINR) * 100)/ sum(Total <Region> ValueINR)

Celambarasan

Re: Aggregate function

Wed, 01 Feb 2012 09:15:12 GMT

You can use

sum(ValueINR) / sum(Total ValueINR) as expression and than in the Presentation tab choose Show in percent (also choosing number or fixed to).

Re: Aggregate function

kaushiknsolanki — Wed, 01 Feb 2012 09:15:32 GMT

HI,

Add straight table with dimension as region, and expression as Sum((Value INR) / sum( total (Value INR)

Have a look at the attched file.

Regards,

Kaushik Solanki