Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Qlik.com |Qlik Help |Resources
Ask a Question
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
HelpSign In / Register
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Announcements
Document boards are being consolidated, this board no longer allows NEW documents
READ MORE- Qlik Community
- :
- Forums
- :
- Analytics
- :
- QlikView
- :
- Documents
- :
- How to Create a Profit and Loss Statement in QlikV...
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Jennell_McIntire
Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to Create a Profit and Loss Statement in QlikView
Last Update:
Aug 10, 2012 9:56:45 AM
Updated By:
Jennell_McIntire
Created date:
Aug 10, 2012 9:56:45 AM
Attachments
Excel Files.zip
How to Create a Profit and Loss Statement.qvw
How to Create a Profit and Loss Statement in QlikView - Technical Brief.zip
How to Create a Profit and Loss Statement - Percentage.zip
Have you ever created a P&L statement in QlikView? Well, this technical brief outlines how to create a P&L statement in QlikView 11 using IntervalMatch.
Also check out this blog post.
Thanks,
Jennell
Tags (11)
- Tags:
- best_practice
- demo
- demo_and_best_practices
- developer
- excel
- intervalmatch
- profit_and_loss
- qliktech
- qlikview
- scripting
Labels (1)
Labels:
Scripting
70,655 Views
72Likes
Comments
Jennell_McIntire
Employee
2012-10-3001:12 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi,
I am not sure I understand your question. It looks like the data you have are the subtotals. Is that correct? If so, yes you can work with that, you will just not have the accounts/values that make up the subtotal values.
Kind Regards,
Jennell
0Likes
Jennell_McIntire
Employee
2012-11-2611:11 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi Paul,
I have added a ZIP file to the original post titled "Excel Files.zip" which includes all the files I used in creating the example app. I hope this helps.
Kind Regards,
Jennell
1Like
Not applicable
2012-12-0102:57 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi Jennell
Thanks a lot for posting such a frequently needed topic. I was looking exactly for such help..
Can you please upload Personal Edition enabled QV Doc?
BR
SAK
0Likes
Jennell_McIntire
Employee
2012-12-0311:22 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
SAK,
I have uploaded the "How to Create a Profit and Loss Statement.qvw" in the original post with an embedded license so you should be able to download and view the QVW now.
Kind Regards,
Jennell
0Likes
sebastiandperei
Specialist
2013-01-1703:18 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi Janell, thanks for this solution.
It is a very easy and elegant way to resolve the most simple P&L reports.
Thanks!
0Likes
spyrosd80
Contributor II
2013-01-2106:18 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi Janell,
Your solution is great!!!
I have a question for you.
Is it possible to add a column where I can calculate the % of Sales for Gross Sales,Sales Return, Off Invoice Discounts and Sales Promotions?
In other words Gross Sales/Net Sales, Sales Return/Net Sales etc ?
Thank you!!!!
1Like
Jennell_McIntire
Employee
2013-02-0803:59 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Sorry for the delay.
In the original post (above) I added a ZIP file named How to Create a Profit and Loss Statement - Percentage.zip showing an example of how you can add the gross sales/net sales.
In the Excel file, I added a row for this new heading as well as a flag and a format column.
In the QVW, I added a key field to the Account Balance table named PeriodKey and I added all the script on the Main 5 tab where I created a new table that stores the net sales value. In the chart on the UI, I modified the Actual expression to either calculate the sales value or the percentage.
Hope this helps!
Jennell
0Likes
Not applicable
2013-06-1211:52 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi Janeell,
It's an excellent paper posted by you. My query is also the same as of spyrosd80, as to how to calculate column for % of sales for all the P&L Items.
Thanks
Saurabh
1Like
Not applicable
2013-07-1111:42 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Thanks for this Jennell. It has really helped me move forward with an assignment.
I am having one difficulty though and that is preserving the blank rows within the chart. I followed the sample and have compared the provided QVW side by side with the one that I created and cannot see what I'm missing. It's simply rolling each of the 'blanks' up to a single row at the top of my chart. I confirmed that it is doing this for each of the 's' rows in my spreadsheet by putting in a counter value.
Any further insight into how this aspect of it should be implemented?
Thanks,
Lorna
0Likes
Jennell_McIntire
Employee
2013-07-1111:59 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi Lorna,
There are 2 things I would check:
- In the Excel file that has the format for the statement (ExecProfitLoss.xls in my example), make sure you have an 's' in the Exec P&L Level column if the row should be blank.
- In the QVW expressions, use an if statement to see if Exec P&L Level = 's', if it does, display an empty string otherwise display the calculation. Here is an example: if([Exec P&L Level] = 's','',Sum({<[Fiscal Year]={$(vYTDYear)} >} [Amount])).
Hope this helps. Good luck!
Jennell
0Likes
- «Previous
- 1
- 2
- 3
- 8
- Next»
Version history
Last update:
2012-08-1009:56 AM
Updated by:
Jennell_McIntire