P&L for Sense?

[teiswamsler]

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

[kavicsgym]

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 🙂

[rwunderlich]

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

-Rob

[kavicsgym]

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 · Accepted solution]

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]

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]

You're welcome

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

Bruno

[kavicsgym]

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

[teiswamsler]

Thanks Bruno

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

/Teis

[brunobertels]

Hi Teis

Great Job   I'am glad it works well

Regards

Bruno