topic Re: P&L for Sense? in App Development

P&L for Sense?

teiswamsler — Wed, 04 Nov 2015 13:15:22 GMT

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

Re: P&L for Sense?

kavicsgym — Tue, 24 Nov 2015 22:03:18 GMT

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?

rwunderlich — Tue, 24 Nov 2015 23:29:32 GMT

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

-Rob

Re: P&L for Sense?

kavicsgym — Wed, 25 Nov 2015 08:14:07 GMT

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ö

Re: P&L for Sense?

brunobertels — Wed, 25 Nov 2015 08:20:14 GMT

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

Re: P&L for Sense?

kavicsgym — Wed, 25 Nov 2015 10:15:38 GMT

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ő

Re: P&L for Sense?

brunobertels — Wed, 25 Nov 2015 11:27:22 GMT

You're welcome

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

Bruno

Re: P&L for Sense?

kavicsgym — Thu, 26 Nov 2015 13:46:50 GMT

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

Re: P&L for Sense?

teiswamsler — Fri, 27 Nov 2015 14:11:45 GMT

Thanks Bruno

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

/Teis

Re: P&L for Sense?

brunobertels — Mon, 30 Nov 2015 09:55:09 GMT

Hi Teis

Great Job I'am glad it works well

Regards

Bruno