topic Re: Adding customer dimension row in QlikView

Adding customer dimension row

didierodayo — Thu, 12 Oct 2017 02:03:45 GMT

Hello,

I am trying to add a new Dimension row to this pivot table that will give me the Surplus/Deficit (Revenue- Expense). What would a neat way of doing this be?

LOAD * INLINE [
Type, Code, Value
Revenue, UK, 50000
Revenue, UK, 25000
Expense, UK, 35000
Expense, UK, 54000
Expense, US, 40000
Revenue, US, 20000
Revenue, US, 60000
];

thanks

Re: Adding customer dimension row

aarkay29 — Thu, 12 Oct 2017 02:15:37 GMT

May be this

Re: Adding customer dimension row

didierodayo — Thu, 12 Oct 2017 02:54:16 GMT

I don't want to change the table structure. I just want to add a new row below Expense (Surplus/Deficit) which displays the value of Revenue - Expense.

thanks

Re: Adding customer dimension row

inoruoya — Thu, 12 Oct 2017 03:14:22 GMT

like this

I use expression "sum({<Type={Revenue}>}Value) - sum({<Type={Expense}>}Value)"