topic Re: Expression in straight Table - Align right with Padding in QlikView

Expression in straight Table - Align right with Padding

Tue, 30 Sep 2014 15:21:55 GMT

I need to keep some space (2 spaces) between the actual number(right aligned) and the border. I tried using TEXT(NUM(Sales,'$ ###,#0')) & ' ' and few other methods (chr(10), RPAD etc).

Anyone tried? Please respond. Thanks, Ganesh.

Re: Expression in straight Table - Align right with Padding

Tue, 07 Oct 2014 15:47:15 GMT

Anyone got a chance to try this? I tried that this is possible to Pivot table but not working for Straight Table. In Pivot table I add a blank column and remove borders before that column. It gives the same effect.

Re: Expression in straight Table - Align right with Padding

Anonymous — Tue, 07 Oct 2014 19:22:33 GMT

Hi,

How about:

=SUM(1000)&' '&CHR(15)

Right align Text and Numeric.

Kind regards

Niklas

Re: Expression in straight Table - Align right with Padding

ecolomer — Tue, 07 Oct 2014 20:46:13 GMT

See this option:

=Num(Importe, '#.##0,00 € ')&' '&'|'

Re: Expression in straight Table - Align right with Padding

Tue, 07 Oct 2014 21:31:20 GMT

Thanks Niklas. That worked. Thanks all for your time.

Re: Expression in straight Table - Align right with Padding

Tue, 07 Oct 2014 21:35:47 GMT

Unfortunately it doesn't work in Webview. I am assuming it wont in Accesspoint too.

Just marked unanswered to get some more inputs if i can.

Re: Expression in straight Table - Align right with Padding

Anonymous — Tue, 07 Oct 2014 21:44:53 GMT

Are you sure?

It is just a question of how many spaces you put in.

See WebView example below with and without spaces.

Re: Expression in straight Table - Align right with Padding

Fri, 10 Oct 2014 15:48:50 GMT

Sorry Niklas, I am trying to see what could be wrong. Your screen does show it is working. It is not the number of spaces, I tried and not working.