Profit and Loss report in Qlik Sense

[jarno_loubser]

We do a lot of financial statements in QlikView with proper formatting:

1. Some bold lines - some not;
2. Blank lines;
3. Heading lines;
4. Sub totals;
5. Different number formats in one column in one object;

The question is - is all (any) of this possible in Qlik Sense?

[paul_scotchford]

Can you post a sample image of what require, QS is limited in these features, but you could look at the extension at  SmartReporting

[reddy-s]

Hi Jarno,

1. Some bold lines - some not : this you can use the colour formatting to achieve it
2. Blank lines - you cannot have a black line. but if you can modify the data model a little, you can achieve this.
3. Heading lines - Pivot table has sub totals and headings as shown in the image below
4. Sub totals - Pivot table has sub totals and headings as shown in the image below
5. Different number formats in one column in one object - totally possible

Thanks,

Sangram.

[Mark_Little]

Hi,

Used this post as a basis

How to Create a Profit and Loss Statement in QlikView

Mark

[jarno_loubser]

Thank you - I will look at the extension.