Discussion Board for collaboration related to QlikView App Development.
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,
Please guide me
Sum(Volume) for the Volume calculation
Sum(Volume * Price) for Revenue
then use partial sum as before
Hope this helps
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
if(count(Category) = 1,
sum(VOL * PRICE)
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.
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.
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.