Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a pivot table looks like above dimension is drill down group division and service line. I want the expressions on top and remove the drill down group and show all the data like below:
Division | Service line | Income | Direct Costs | Indirect Costs | Total Direct & Indirect Costs | . | Contribution |
Children Service | Children Nursing-SLCCN | ||||||
Radiology Direct Access-SLRADDA | |||||||
Hi azadeh,
I have recently created an income statement in qlikview and i may be able to help you.
If your pivot table is already present in qlikview, i will suggest just drag and drop to swap the column and row dimension.
If you are asking how to come up with expression for income statement i will suggest using interval match function , assuming the revenue items are already positive figures and cost item are negative figures.
refer to this post for more information how to use interval match function How to Create a Profit and Loss Statement in QlikView
If you want the exact expression and script to use, post your qvw and i may be able to help.
Regards,
TK
please post a sample application to demonstrate.
thanks
regards
Marco
Hi azadeh,
I have recently created an income statement in qlikview and i may be able to help you.
If your pivot table is already present in qlikview, i will suggest just drag and drop to swap the column and row dimension.
If you are asking how to come up with expression for income statement i will suggest using interval match function , assuming the revenue items are already positive figures and cost item are negative figures.
refer to this post for more information how to use interval match function How to Create a Profit and Loss Statement in QlikView
If you want the exact expression and script to use, post your qvw and i may be able to help.
Regards,
TK
many thanks , drag and drop to swap the column works for me.
no problem, glad that it works