topic Re: Value and Volume in a single table in QlikView

Value and Volume in a single table

santhosh_k_n — Thu, 08 May 2014 11:13:02 GMT

Hi all,

I am showing volume details in all the expressions used in a pivot table.

But now I need to show value(volume * Price) as a next line to the total volume(partial sum property in presentation tab).

The requirement as follows,

category	Model ID	volume
A	1	100
A	2	150
Total(Partial sum on category)	-	250
(Requirement) Total Value		=(10012)+(15010)= 2700

Please guide me

Re: Value and Volume in a single table

Roop — Thu, 08 May 2014 11:41:33 GMT

Try:

Sum(Volume) for the Volume calculation

and

Sum(Volume * Price) for Revenue

then use partial sum as before

Hope this helps

Re: Value and Volume in a single table

santhosh_k_n — Thu, 08 May 2014 12:16:02 GMT

Hi Rupert,

As per your suggestion, I need to add a another expression which will again a separate column.

But i dont need as a separate column but to display the total value as next row to total volume

Re: Value and Volume in a single table

Roop — Thu, 08 May 2014 12:28:11 GMT

How about:

if(count(Category) = 1,

Sum(VOL),

sum(VOL * PRICE)

)

Re: Value and Volume in a single table

rajat2392 — Thu, 08 May 2014 12:31:22 GMT

Hi Santosh,

What you are asking is not possible.

What you can do is faking. Take a Text Object and layout it similar to table and place it below the the table with the calculation you want.

Regards

Rajat

Re: Value and Volume in a single table

santhosh_k_n — Thu, 08 May 2014 12:36:39 GMT

I tried this and this works fine for Table box/ straight table.

But am using Pivot table with collapse fields so displaying the text objects when collapse will be lost when field expanded.

Re: Value and Volume in a single table

rajat2392 — Thu, 08 May 2014 12:45:32 GMT

So what you can do is go to pivot table properties, under presentation tab check for always fully expanded, if there is no specific requirement for a collapsed table.

Regards

Rajat