Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

Profit and Loss Statement in Qliksense

Hi Experts,

Can any one please provide the Demo app for understanding the Profit and Loss Statement in Qliksense with PLSmart Extension or with any other best way.

Thanks in advance.

3 Replies

Re: Profit and Loss Statement in Qliksense

There's a demo app on the github site of the plsmart extension: GitHub - iviasensio/PL-Smart


talk is cheap, supply exceeds demand
mahitham
Contributor

Re: Profit and Loss Statement in Qliksense

Hi,

I have seen that App.

In a separate Excel file I have taken the below source from the extension source with only few columns like below.

I think the grey highlighted rows are calculated values. Please help me how to Implement this in qliksense.

P&LSOurce.png

when i have taken in to qliksense these are looks like below its not matching with above headings.

Please explain this App once.

P&L SENSE.png

Thanks in advance !

ogster1974
Honored Contributor II

Re: Profit and Loss Statement in Qliksense

You just need to custom sort on your dimension. You can use valuelist() to define the specific order you want presented.