Discussion Board for collaboration on QlikView Layout & Visualizations.
Currently I try to generate Trial Balance report. And my problem is on format the report.
1. Here is the pivot table format in QlikView:
2. The format that I need is add Debit/Credit column in each column PER01,PER02,PER03
(If amount>0 then we put it in Debit column and if amount<0 then we put in Credit column)
How can I add column Debit/Credit in QlikView like format(2)?
Please help to check and modify in the attached file.
Go to Solution.
See the attached file
Its look easy when ever you want to display a table like try to load data in different ways which makes easy.
Here look at the sample attached file try to load data in this manner.
See the latest updated sample file Qvw file it is updated.
Thanks for your reply. In my datasource have only field AccID,PER01,PER02,PER03 and not load data from Excel also. So Debit/Credit column need to customize in pivot table.
Do you have any idea besides above solution? Please take a look in my attached file and modify on it.
Appreciated your solution.
Thanks for your reply. It correct.