topic Re: Expression to align vertically and insert horizontal spaces in QlikView

Expression to align vertically and insert horizontal spaces

Thu, 30 Jul 2015 10:44:47 GMT

Hello,

Hopefully this is a simple task.

I have a test box which contains 6 expressions within which contains phrases. The expressions show a summary of KPIs and their corresponding values. See below.

'KPI 1' &' = '& Expression 1

&','

'KPI 2' &' = '& Expression 2

&','

'KPI 3' &' = '& Expression 3

&','

'KPI 4' &' = '& Expression 4

&','

'KPI 5' &' = '& Expression 5

&','

'KPI 6' &' = '& Expression 6

With the above set up and by re-sizing the text box, the KPIs and their corresponding values are tightly stacked on top of each other such as follows....

KPI 1 = 10

KPI 2 = 11

KPI 3 = 12 etc

I would like the above expression to be written such that the end result has horizontal spaces between each KPI and appears as seen below..........

KPI Name

KPI 1 = 10

KPI 2 = 11

KPI 3 = 12 etc

Any ideas please?

Re: Expression to align vertically and insert horizontal spaces

marcus_malinow — Thu, 30 Jul 2015 10:49:21 GMT

Try adding chr(10)'s (carriage returns)

'KPI 1 = ' & Expression 1 & ',' & chr(10) & chr(10) &

'KPI 2 = ' & Expression 2 & ',' & chr(10) & chr(10)

etc..

Re: Expression to align vertically and insert horizontal spaces

sunny_talwar — Thu, 30 Jul 2015 10:51:19 GMT

Try if this helps:

='KPI 1' &' = '& Expression 1 & Chr(10) & Chr(10) &

'KPI 2' &' = '& Expression 2 & Chr(10) & Chr(10) &

'KPI 3' &' = '& Expression 3 & Chr(10) & Chr(10) &

'KPI 4' &' = '& Expression 4 & Chr(10) & Chr(10) &

'KPI 5' &' = '& Expression 5 & Chr(10) & Chr(10) &

'KPI 6' &' = '& Expression 6 & Chr(10) & Chr(10)

Re: Expression to align vertically and insert horizontal spaces

alexandros17 — Thu, 30 Jul 2015 10:52:19 GMT

Is this useful?

'KPI 1' &' = '& '111'

& chr(10) & chr(10) &

'KPI 2' & ' = '& '222'

& chr(10) & chr(10) &

'KPI 3' &' = '& '333'

& chr(10) & chr(10) &

'KPI 4' &' = '& '444'

& chr(10) & chr(10) &

'KPI 5' &' = '& '555'

& chr(10) & chr(10) &

'KPI 6' &' = '& '666'

Re: Expression to align vertically and insert horizontal spaces

antoniotiman — Thu, 30 Jul 2015 11:06:11 GMT

=Repeat(' ',20)&'KPI Name'&Chr(10)&Chr(10)

&'KPI 1 = '&Expression&Chr(10)&Chr(10)

&'KPI 2 = '&Expression&Chr(10)&Chr(10)

&'KPI 3 = '&Expression&Chr(10)&Chr(10)

..............

Re: Expression to align vertically and insert horizontal spaces

Kushal_Chawda — Thu, 30 Jul 2015 11:16:55 GMT

something like this

'KPI 1' &' = '& Expression 1 & Chr(13) &

'KPI 2' &' = '& Expression 2 & Chr(13) &

'KPI 3' &' = '& Expression 3 & Chr(13) &

'KPI 4' &' = '& Expression 4 & Chr(13) &

'KPI 5' &' = '& Expression 5 & Chr(13) &

'KPI 6' &' = '& Expression 6 & Chr(13)

Re: Expression to align vertically and insert horizontal spaces

awhitfield — Thu, 30 Jul 2015 11:30:46 GMT

PS Chr(10) returns a linefeed character, just in case you ask!

Andy

Re: Expression to align vertically and insert horizontal spaces

Thu, 30 Jul 2015 11:55:51 GMT

Thanks guys,

That's great. All the suggestions worked. Thank You!

But one last thing. The values are returned with over 5 decimal places (as a percentage). How do I restrict the values to only 2 decimal places for example? The expression I tried is as follows but it did not work...

=sum((Expression)*100,'#.00')