Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

santhosh_k_n
Contributor II

Value and Volume in a single table

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,

categoryModel IDvolume
A1

100

A2

150

Total(Partial sum on category)-250

(Requirement)

Total Value

=(100*12)+(150*10)= 2700

Please guide me

Tags (1)
6 Replies
rupe
Valued Contributor

Re: Value and Volume in a single table

Try:

Sum(Volume) for the Volume calculation

and

Sum(Volume * Price) for Revenue

then use partial sum as before

Hope this helps

santhosh_k_n
Contributor II

Re: Value and Volume in a single table

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

rupe
Valued Contributor

Re: Value and Volume in a single table

How about:

if(count(Category) = 1,

     Sum(VOL),

     sum(VOL * PRICE)

)

Highlighted
Partner
Partner

Re: Value and Volume in a single table

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

santhosh_k_n
Contributor II

Re: Value and Volume in a single table

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.

Partner
Partner

Re: Value and Volume in a single table

Hi

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