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

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

Sokkorn — Thu, 25 Aug 2011 01:50:01 GMT

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

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

Thu, 25 Aug 2011 03:00:14 GMT

I got ur problem can yousend me your excel

thanks

Meher

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

Thu, 25 Aug 2011 03:19:29 GMT

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;

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

Sokkorn — Thu, 25 Aug 2011 04:13:58 GMT

Hi DHutchins,

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

Many thanks for your support.

Regards,

Sokkorn

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

Sokkorn — Thu, 25 Aug 2011 04:14:30 GMT

Hi Merwan,

The data that I load is not from excel file.