Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Indenting specific rolls on a straight table

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;

1 Solution

Accepted Solutions
Highlighted

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,

View solution in original post

7 Replies
Highlighted

May be use Dual() here

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


Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator III
Creator III

Unfortunately that didn't work for me

Highlighted

Try setting verbatim = 1 at the beginning of the script

set Verbatim = 1;

Highlighted

Read here about it

Verbatim

Creator III
Creator III

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?

Highlighted

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,

View solution in original post

Highlighted
Creator III
Creator III

Actually it did work - apologies.  Thanks for your help