Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
paul_ripley
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
sunny_talwar

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
Anil_Babu_Samineni

May be use Dual() here

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


Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
paul_ripley
Creator III
Creator III
Author

Unfortunately that didn't work for me

sunny_talwar

Try setting verbatim = 1 at the beginning of the script

set Verbatim = 1;

sunny_talwar

Read here about it

Verbatim

paul_ripley
Creator III
Creator III
Author

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?

sunny_talwar

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,

paul_ripley
Creator III
Creator III
Author

Actually it did work - apologies.  Thanks for your help