Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need to know about P&L Statments

Hi,

I just need a brief explanation about P&L statements used in qlikview. I glanced the link How to Create a Profit and Loss Statement in QlikView‌ but i couldn't get much clarity about it. Please provide me a better reference link or an example for me to understand this concept.

3 Replies
Or
MVP
MVP

The link above already contains all the information you need, including examples. What seems to be the problem, specifically?

Anonymous
Not applicable
Author

In this How to Create a Profit and Loss Statement in QlikView‌ document, I saw the video explaining about the whole report creation. I couldn't understand why we use the intervalmatch function. I get the whole logic behind the calculations and expressions part, but i don't know why there's a creation of inline statements and intervalmatch function.

Here I dont know why we create a inline statement.

pic1.PNG

Second, I dont know why we use intervalmatch function:pic2.PNG

Or
MVP
MVP

In this context, IntervalMatch is used to assign each line in the data to the correct sections of the P&L report. Unlike typical reporting, P&L reports often display the same line multiple times - for example, a sales line might be displayed in Gross Sales, Net Sales, Gross Margin, Operating Income, and Net Income. This means we can't assign it the "normal" way. Instead, the process used it to read the lines, read (and enumerate) the sections, and then use IntervalMatch to load the lines into the appropriate sections.