Need to have a sample P & L Statement made in Qlik Sense

[Anonymous]

Hi, I want to create Profit and Loss Statement with certain period of closing (Current Year/Last Year and Current Month/Last Month) with specific range of account number to categorize the account nature.

Example: (Figures are assumed)

Description	Jul-17	Jun-17	Total Year       Last Year
Net Sales	54,014	64,540	450544               45054
Cost of Sales	56,556	66,844	140544               64454
Gross Profit	56,454	445,044	5778                   48074
Sales and distribution expenses	-54,571	-56,477
General and administration expenses		-65,644
Operating Income	54,045	-65,644
Financial Charges	-45,404	-1,444
Net Income	2,540	-3,454	145054                45877

Looking forward to have a sample Qlik Sense App.

Thanks

[devarasu07]

Hi,

try this, same way u can create in qliksense as well.

How to Create a Profit and Loss Statement in QlikView

How IntervalMatch Solved My Profit and Loss Dilemma

[Anonymous]

I have this in Qlik View, but I'm not familiar with Qlik view. If possible Qlik Sense please.

[Anonymous]

Can you attach the qlikview file? I'm new to P&L concept as well.