Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've a table with fields like below
id address
1 abcdefr
2 abcdreftt
3 abdcsdfgtr
4 abbqweds
5 abbcddfgf
6 acvbjhgfdd
I would like to wrap this dynamically for each 3 chars of the field address.
I can have a solution like below but need to do it dynamic.
if(len(address)>3,left(address,3)&chr(10)&right(address,len(address)-3)) as newaddress
the newaddress will have values like below
id newaddress
1 abc
defr
2 abc
dreftt
3 abd
csdfgtr
but what I'm trying to achieve is like below
id newaddress
1 abc
def
r
2 abc
dre
ftt
3 abd
csd
fgt
r
I'm creating alerts in QlikView. Since the alerts Subject panel does not have format options or options for embedding charts/tables so I'm trying to create a table like format for the data to be put in the Alert Subject section. Some lengthy field values are creating trouble so I'm trying to wrap them.
Any suggestions please. Thanks in advance.
Sudeep Mahapatra wrote:
Just one thing which I found is that when I use spaces in the values of the Field address the newaddress field is changing.
I'm not sure if I see the values of newaddress changing, but they don't enforce sort according to the input sequence. If you want to enforce FIFO, I added that.
(i.e. address = 1AU2BE3CO4HE
newaddress = 1AU
2BE
3CO
4HE)