Indent the rows

[vireshkolagimat]

Hi, How to get the below data as is the Qlikview table and also in the nPrinting.

Desc	Sales1	Sales2	Sales3
Prod A	2	3	4
subprodB1	1	1	1
subprodB2	2	2	2
Prod B	3	3	3
subprodC1	3	4	5
subprodC11	2	7	1
Prod C	5	11	6
prod D	2	4	6

[vireshkolagimat]

I am trying to use the dual function like below  =Dual(repeat(chr(9),IndentLevel)&HeaderName, HeaderName)

but still the result is not sorted.

[vinieme12]

Right Click on the chart >> Properties >> Sort Tab >>

     Tick Sort by Expression >> Ascending and put expression in highlighted area as      "=SortOrder"

[vireshkolagimat]

Hi Vineeth,

yes i got it.

I am getting a half a inch indent if i set the IndentLevel equal to 1, which is more than the required. Is there any way to reduce the indent.

Actually it is not obvious in Qlikview but when i try to show the table thru nPrinting, it is showing more space.

Regards,

Viresh

[vinieme12]

try chr(160) instead of chr(9)

[vireshkolagimat]

Hi, thanks it's working.

Can we produce the same result in nPrinting using levels or any other option.

Thanks

Viresh

[vinieme12]

I've not had a chance to work with NPrinting yet

But i'm hopefull