Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Sokkorn
Honored Contributor

I have problem in the attached file. Please help ASAP.

Hi All,

Please take your value time to help me a little bit in the attached file. I really need it ASAP.

Thanks in advanced!

Regards,

Sokkorn

1 Solution

Accepted Solutions
Not applicable

Re: I have problem in the attached file. Please help ASAP.

One possible solution:  Use CROSSTABLE to create a variation of your data table, then add a column to indicate 'Debit' or 'Credit', then rework the Pivot table accordingly.  See load script below, and see attached QVW.
[TrialBalance]:
LOAD * INLINE
[AccID,           PER01,     PER02,     PER03
111-10-10-10,     0,          0,          -2809
111-10-10-20,     0,          -1154,     25
111-20-10-10,     2800,     2800,     1500
111-30-10-10,     -1000,     1000,     2300
112-10-10-10,     1000,     1500,     2700
112-10-10-20,     0,          1390,     570
112-11-10-10,     3698,     2000,     0]
;

TrialBalance_Temp:
CrossTable( Period, DCValue )
Load *
resident TrialBalance;

TrialBalance_DC:
Load
IF( DCValue >= 0, 'Debit', 'Credit' ) As DC,
*
resident TrialBalance_Temp;
drop table TrialBalance_Temp;
drop table TrialBalance;
4 Replies
Not applicable

I have problem in the attached file. Please help ASAP.

I got ur problem can yousend me your excel

thanks

Meher

Not applicable

Re: I have problem in the attached file. Please help ASAP.

One possible solution:  Use CROSSTABLE to create a variation of your data table, then add a column to indicate 'Debit' or 'Credit', then rework the Pivot table accordingly.  See load script below, and see attached QVW.
[TrialBalance]:
LOAD * INLINE
[AccID,           PER01,     PER02,     PER03
111-10-10-10,     0,          0,          -2809
111-10-10-20,     0,          -1154,     25
111-20-10-10,     2800,     2800,     1500
111-30-10-10,     -1000,     1000,     2300
112-10-10-10,     1000,     1500,     2700
112-10-10-20,     0,          1390,     570
112-11-10-10,     3698,     2000,     0]
;

TrialBalance_Temp:
CrossTable( Period, DCValue )
Load *
resident TrialBalance;

TrialBalance_DC:
Load
IF( DCValue >= 0, 'Debit', 'Credit' ) As DC,
*
resident TrialBalance_Temp;
drop table TrialBalance_Temp;
drop table TrialBalance;
Sokkorn
Honored Contributor

Re: I have problem in the attached file. Please help ASAP.

Hi DHutchins,

Thanks for your script. It correct one that I need.

Many thanks for your support.

Regards,

Sokkorn

Sokkorn
Honored Contributor

Re: I have problem in the attached file. Please help ASAP.

Hi Merwan,

The data that I load is not from excel file.

Community Browser