Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jarno_loubser
Contributor

Profit and Loss report in Qlik Sense

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?

4 Replies
paul_scotchford
Valued Contributor

Re: Profit and Loss report in Qlik Sense

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

reddys310
Honored Contributor II

Re: Profit and Loss report in Qlik Sense

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

Capture.PNG

Thanks,

Sangram.

mark6505
Valued Contributor III

Re: Profit and Loss report in Qlik Sense

jarno_loubser
Contributor

Re: Profit and Loss report in Qlik Sense

Thank you - I will look at the extension.

Community Browser