Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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:
AccID | PER01 | PER02 | PER03 |
111-10-10-10 | $0.00 | $0.00 | ($2,809.00) |
111-10-10-20 | $0.00 | ($1,154.00) | $25.00 |
111-20-10-10 | $2,800.00 | $2,800.00 | $1,500.00 |
111-30-10-10 | ($1,000.00) | $1,000.00 | $2,300.00 |
112-10-10-10 | $1,000.00 | $1,500.00 | $2,700.00 |
112-10-10-20 | $0.00 | $1,390.00 | $570.00 |
112-11-10-10 | $3,698.00 | $2,000.00 | $0.00 |
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)
AccID | PER01 | PER02 | PER03 | |||
Debit | Credit | Debit | Credit | Debit | Credit | |
111-10-10-10 | $0.00 | $0.00 | $0.00 | $2,809.00 | ||
111-10-10-20 | $0.00 | $0.00 | $1,154.00 | $25.00 | ||
111-20-10-10 | $2,800.00 | $2,800.00 | $1,500.00 | |||
111-30-10-10 | $0.00 | $1,000.00 | $1,000.00 | $2,300.00 | ||
112-10-10-10 | $1,000.00 | $1,500.00 | $2,700.00 | |||
112-10-10-20 | $0.00 | $1,390.00 | $570.00 | |||
112-11-10-10 | $3,698.00 | $2,000.00 | $0.00 |
How can I add column Debit/Credit in QlikView like format(2)?
Please help to check and modify in the attached file.
Regards,
Sokkorn Cheav
Hi,
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.
Regards,
Anand
Hi,
See the latest updated sample file Qvw file it is updated.
Regards,
Anand
Hi Anand,
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.
Regards,
Sokkorn
Hi
See the attached file
Hi qliksus,
Thanks for your reply. It correct.