Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

teiswamsler
Contributor II

P&L for Sense?

Hi there

Have any Experts fallen over a working solution for an P&L in Qlik Sense?

I can make it with scripting and a stright table, but it will not look as great as in Qlikview.

Need a solution where i can tab in text, and have multiple subaccount ex.

Please point me i the right direction.

Thanks!

/Teis

1 Solution

Accepted Solutions
brunobertels
Valued Contributor

Re: P&L for Sense?

Hi

I'm not sure it's near by what you're looking for but have you try this extension :

http://branch.qlik.com/projects/showthread.php?609-SmartReporting&highlight=P%26amp%3BL+smart

Bruno

9 Replies
kavicsgym
Contributor

Re: P&L for Sense?

Hi, I am working on a demo for a prospect right now. I made it in QV first and now replicating in QS. As a quick solution for 'tabbing in the text' I simply added dots instead of the  spaces before the reprotrows.   '. . . . . . '&Reportrows

Just a quick fix... no solution yet for text formatting though :-)

Re: P&L for Sense?

For the indentation, try "repeat(chr(160),8)" instead of dots.

-Rob

kavicsgym
Contributor

Re: P&L for Sense?

Thanks a lot, Rob.

So instead of Chr(32) Chr(160) with the repeat() works nicely.

Can we shomehow code the formatting (as Bold, Italic, etc.) of selected lines in the P&L as it worked in QV?

Enikö

brunobertels
Valued Contributor

Re: P&L for Sense?

Hi

I'm not sure it's near by what you're looking for but have you try this extension :

http://branch.qlik.com/projects/showthread.php?609-SmartReporting&highlight=P%26amp%3BL+smart

Bruno

kavicsgym
Contributor

Re: P&L for Sense?

Hi Bruno,

Thanks for the link, it looks pretty much what I need!!

I just have to dig myself to it and start using.

Thanks, Enikő

brunobertels
Valued Contributor

Re: P&L for Sense?

You're welcome

closed the thread if it's OK for you or clik on answered or usefull bouton

Bruno

kavicsgym
Contributor

Re: P&L for Sense?

Sorry, I did not start the thread.... But thanks anyway for the help!!!

teiswamsler
Contributor II

Re: P&L for Sense?

Thanks Bruno

Just what i needed, it has been testet, implemented and works just fine, and the cutomer is very happy

/Teis

brunobertels
Valued Contributor

Re: P&L for Sense?

Hi Teis

Great Job   I'am glad it works well

Regards

Bruno