topic Indenting specific rolls on a straight table in QlikView

Indenting specific rolls on a straight table

paul_ripley — Tue, 01 May 2018 08:25:43 GMT

Hello

I have a PnL report and I would like to have some lines indented but not the subtotal lines.

Below is the Excel template I am using

This is what the report looks like

And this is the code below.ve tr

Specifically I have tried to add spaces using

if([Roll up] = 'Rollup', pl_line_ifrs, ' ' & pl_line_ifrs ) as pl_line_ifrs,

But then also tried chr functions but cant seem to get them to work. Can anyone please assist

Thanks

Paul

IS_Layout:
LOAD
[code pl] as %Key_PL,
[code pl] ,
[code groupcoa],
if([Roll up] = 'Rollup', pl_line_ifrs, ' ' & pl_line_ifrs ) as pl_line_ifrs,
if(len(trim([Roll up]))=0,'Line','Subtotal') as pl_rollup,
pl_text_format,
pl_background
FROM [$(vPath_SourceData_XLS)\Layout_3i_IFRS_IncomeStatement.xlsx]
(ooxml, embedded labels, header is 1 lines, table is IFRS_IS_Layout);

STORE IS_Layout INTO [$(vPath_StagingData_S2)\IS_Layout.qvd] (qvd);
Drop Table IS_Layout;

Re: Indenting specific rolls on a straight table

Anil_Babu_Samineni — Tue, 01 May 2018 08:30:06 GMT

May be use Dual() here

If([Roll up] = 'Rollup', pl_line_ifrs, Dual(' ' & pl_line_ifrs, pl_line_ifrs)) as pl_line_ifrs,

Re: Indenting specific rolls on a straight table

paul_ripley — Tue, 01 May 2018 08:47:21 GMT

Unfortunately that didn't work for me

Re: Indenting specific rolls on a straight table

sunny_talwar — Tue, 01 May 2018 09:09:37 GMT

Try setting verbatim = 1 at the beginning of the script

set Verbatim = 1;

Re: Indenting specific rolls on a straight table

sunny_talwar — Tue, 01 May 2018 09:10:26 GMT

Read here about it

Verbatim

Re: Indenting specific rolls on a straight table

paul_ripley — Tue, 01 May 2018 09:29:01 GMT

Ah that didn't work for me also. I don't suppose there's anything I can put on the excel sheet to do this formatting?

Re: Indenting specific rolls on a straight table

sunny_talwar — Tue, 01 May 2018 11:07:17 GMT

So, doing the below thing with Verbatim set to 1 did not work?

if([Roll up] = 'Rollup', pl_line_ifrs, ' ' & pl_line_ifrs ) as pl_line_ifrs,

Re: Indenting specific rolls on a straight table

paul_ripley — Tue, 01 May 2018 13:03:40 GMT

Actually it did work - apologies. Thanks for your help