possible in which way?

[arulsettu]

Hi,

     i am trying to do something like in following excel. so i followed everything according to this concept

How to Create a Profit and Loss Statement in QlikView

but i cant able to achieve what i need.

can anyone tell me how to achieve this

Thanks

[ToniKautto]

What are you saying, the How to Create a Profit and Loss Statement in QlikView is not working as described? If yes, then I think you should address that by asking followup questions in the How to Create a Profit and Loss Statement in QlikView thread.

The attached Excel file only contains headers. I am quite sure you can accomplish headers like this with the guidance from How to Create a Profit and Loss Statement in QlikView‌. If this is not true, then I think the difference might be the data you are loading into QlikView. Could you provide a sample QVW and source data file so that someone can take a closer look at the actual problem your are having?

[arulsettu]

if i change the parameter it showing nothing.

anyone suggest some ideas

Thanks

[arulsettu]

any ideas guys?

[Peter_Cammaert]

What does the field ACNT_COMP_CODE contain? It has 4 values which at the time of the INTERVALMATCH fall in every Start/End range. That cannot be the purpose...

Somehow you should divide your P&L layout into two sections:

• LowLevel sections that group accounts into ranges
• HighLevel sections that aggregate one or more LowLevel sections and / or HighLevel sections.

Peter

[Peter_Cammaert]

There you have it! Why are you using INTERVALMATCH to map a company code into a P&L range? A P&L range specifies which account groups should be aggregated in this particular line. Not company codes...

For a suggestion on how to do this, see my previous post.

Peter

[arulsettu]

can you give a example based on my excel please i cant understand.

Thanks

[Peter_Cammaert]

No because the problem cannot be solved using the excel. The excel is ok. Your other sources are lacking some essential data (and the source QVDs are missing altogether)

Reread the Technical Brief in How to Create a Profit and Loss Statement in QlikView. On page 6 there is a field called  [Reporting Code] which maps every account in the account table to a P&L item. This Reporting code is linked to the various P&L lines where these accounts should be aggregated. Make sure that every account has a place in the P&L, assign the corresponding Reporting Code to the account and replace ACNT_COMP_CODE with [Reporting Code] in the INTERVALMATCH. Reload. Job done.

Peter

[arulsettu]

Hi,

      How they are generating reporting code in P&L sample app further how can i generate reporting code based on my data which will be associated to ACNT_COMP_CODE and i'm having a field Acent_Felx_02 which is acting  like flag  having data as Balance and Income statement.

In the sample app they are having field Account type having data as Balance and P&L.

Please suggest me how can i proceed?

[Peter_Cammaert]

For answers to both questions, contact your accounting dept. They decide which General Ledger account goes into which P&L / Balance reporting category.

Peter