topic pivot table partial sum problem in QlikView

pivot table partial sum problem

Wed, 01 Jun 2011 06:11:59 GMT

Hi,

I have a problem with partial sum. Say I have a dimention 1 call D1 and have two values: a,b. and I have one expression E whose value will depend on D1 value,for example:

if(D1='a',Sum(cost),if(D1='b',Sum(cost)*100,?????))

The partial sum will be incorrect. How to script the ???? part so that the partial sum will correct.

Thanks!

Dihui

pivot table partial sum problem

Anonymous — Wed, 01 Jun 2011 06:14:50 GMT

If using a straight table, Look at using the "Sum of Rows" as the expression total instead of the Expression Default.

If using a pivot table, look up the chapter.. think it's 24.3 in the QV Reference manual regarding Sum of Rows in pivot table.

pivot table partial sum problem

kaushiknsolanki — Wed, 01 Jun 2011 08:11:26 GMT

Hi,

Instead of ???? you can put 0. This will not effect on your partial sum.

Hope this will help you.

Regards,

Kaushik Solanki

pivot table partial sum problem

Thu, 02 Jun 2011 05:54:46 GMT

Hi Johannes,

Still do not find the solution. I am using pivot table. Maybe we read different manuals.....

-dihui

pivot table partial sum problem

Thu, 02 Jun 2011 06:00:29 GMT

Try This:

Sum(if(D1='a',cost,if(D1='b',cost*100)))

pivot table partial sum problem

Thu, 02 Jun 2011 06:16:23 GMT

Thanks Erika,

It works

Re: pivot table partial sum problem

Thu, 02 Jun 2011 06:20:11 GMT

Hi Dihui,

Attached is a sample QVW... I included both method (Erika and Johannes)

The solution can be found in the QlikView 10 manual page 1362 (pdf page)

Re: pivot table partial sum problem

Thu, 02 Jun 2011 06:31:34 GMT

Hi khim_hoe,

very cool, thanks very much!

-Dihui