topic Re: Offset in the table in QlikView

Offset in the table

dzmitry_shmurye — Fri, 25 Mar 2016 11:32:27 GMT

Hi community!

I have the table with the large values in dimention. Some values are in the 2 or more line:

I need add the offset for this values bettween the separator line and the first letter of dimension.

This is the result that I want to get for dimension values (yellow - 2 spaces for every line of the dimension values)

Could enybody help me with this design feature if it is possible?

Thanks!

Re: Offset in the table

sunny_talwar — Fri, 25 Mar 2016 12:02:05 GMT

May be like an expression in straight table:

' ' & Dim2

Re: Offset in the table

dzmitry_shmurye — Fri, 25 Mar 2016 12:04:55 GMT

Thanks for your reply, but some values have 2 line and if I add ' ' & Dim I get the next:

Re: Offset in the table

sunny_talwar — Fri, 25 Mar 2016 12:21:18 GMT

May be this:

' ' & SubField(Dim2, Chr(10), 1) & Chr(10) & ' ' & SubField(Dim2, Chr(10), 2)

Re: Offset in the table

dzmitry_shmurye — Fri, 25 Mar 2016 12:32:43 GMT

How you got this result for Dim1 = 5? I think it should be

MOUNTED

EQUIP

REPAIR

according your formula...

Re: Offset in the table

florentina_doga — Fri, 25 Mar 2016 12:33:44 GMT

try presentetion wrap cell text

Re: Offset in the table

sunny_talwar — Fri, 25 Mar 2016 12:46:42 GMT

So I am not using a space for SubField. I am using Chr(10) which might be coming from your original database, right? Attached is the Excel file I used

Re: Offset in the table

dzmitry_shmurye — Fri, 25 Mar 2016 12:55:12 GMT

In the column 2 you can see initial data (without) separators

In the column 3 you can see the results of your expresion...

Re: Offset in the table

t_chetirbok — Fri, 25 Mar 2016 13:16:51 GMT

If I understand you, you haven't string separated by "Enter" in your data.

so try expression:

=Chr(32)&

if(len(DIM)<=16

,DIM

,if(len(keepchar(DIM,chr(32)))+1=2

, SubField(DIM, Chr(32), 1) & Chr(10) & Chr(32) & SubField(DIM, Chr(32), 2)

, if(len(keepchar(DIM,chr(32)))+1=3

, if(len(SubField(DIM, Chr(32), 1)&SubField(DIM, Chr(32), 2))<=16

, SubField(DIM, Chr(32), 1)&chr(32)&SubField(DIM, Chr(32), 2)& Chr(10) & Chr(32) & SubField(DIM, Chr(32),3)

, SubField(DIM, Chr(32), 1)&chr(10)&chr(10)&Chr(32)&

if(len(SubField(DIM, Chr(32), 2)&SubField(DIM, Chr(32), 3))<=16

, SubField(DIM, Chr(32), 2)&chr(32)&SubField(DIM, Chr(32), 3)

, SubField(DIM, Chr(32), 2)&chr(10)&Chr(32)&SubField(DIM, Chr(32), 3)

)

But it would work if you have 3 words

Re: Offset in the table

sunny_talwar — Fri, 25 Mar 2016 13:30:32 GMT

Can you share the qvw where you tried it out?

Re: Offset in the table

dzmitry_shmurye — Fri, 25 Mar 2016 13:36:34 GMT

Please find the qvw in attachement.

Re: Offset in the table

sunny_talwar — Fri, 25 Mar 2016 14:39:02 GMT

May be this:

=' ' & SubField(Dim2, ' ', 1) & Chr(10) & ' ' & Right(Dim2, Len(Dim2) - Index(Dim2, ' ', 1))

Re: Offset in the table

dzmitry_shmurye — Fri, 25 Mar 2016 14:53:09 GMT

In your example the second words of value always will be on the new line, but it is not correctly, for example, if the length of the first words is only 3 symbols?

I need that the first line include for example 16 symbols always, and if first and second words have < 16 symbols, they should be desplays on the first line and the third words - on the second line if it not placed in 16 symbols.

Thanks!

Re: Offset in the table

dzmitry_shmurye — Fri, 25 Mar 2016 14:58:21 GMT

Regard your example I need get the next:

CAB-SHEET METAL

- <16 symbols (1 line)

AERODYNAMIC

DEVICES

- 2 lines because two words length > 16 symbols

MOUNTED EQUIP

REPAIR

- 2 lines, but the first and second words on the 1 line length < 16 symbols

etc...

Re: Offset in the table

sunny_talwar — Fri, 25 Mar 2016 16:39:29 GMT

May be this:

=If(Len(Dim2) < 16, ' ' & Dim2,

' ' & Left(Left(Dim2, 16), Index(Left(Dim2, 16), ' ', -1)) & Chr(10) &

' ' & Right(Dim2, Len(Dim2) - Len(Left(Left(Dim2, 16), Index(Left(Dim2, 16), ' ', -1)))))

Re: Offset in the table

MarcoWedel — Sat, 26 Mar 2016 01:10:45 GMT

why do you want to indent this column?

Re: Offset in the table

dzmitry_shmurye — Mon, 28 Mar 2016 10:59:29 GMT

Thanks Tatsiana. Your solution is work. For every word in the field I should write own If(). It is useful.

Re: Offset in the table

dzmitry_shmurye — Mon, 28 Mar 2016 11:01:29 GMT

Thanks Sunny!

It is work for me, but if i will have 3 or more line in the table cell, I should add new If() for every line.

It is useful.

Re: Offset in the table

dzmitry_shmurye — Mon, 28 Mar 2016 11:10:12 GMT

This is the design requirement of the customer.

Re: Offset in the table

oknotsen — Mon, 28 Mar 2016 14:53:03 GMT

What is the idea behind the requirement?

In other words: What is it that the customer really wants to achieve?