topic Re: How to editing display text in QlikView

How to editing display text

Thu, 22 May 2014 09:21:20 GMT

I'm newbie in qlikview and I want to add some tables from excel so that two columns merged into one and the fields in the first column was missing some symbols. I tried to realize it like that :

Table:
LOAD[ID],
name as Name,
Group,
Weight,
prise,
Code,
Code2
FROM
[Table.xlsx]
(ooxml, embeddedlabels)

Where concat(Code=Replace(Code, Chr(6-7), ""), Code2);

but it doesn't works.

Help me, please

Re: How to editing display text

tresB — Thu, 22 May 2014 09:22:51 GMT

Not sure of your issue. But first look says, some errors:

Table:

LOAD [ID],

name as SomeName, // Error1 -

Group,

Weight,

prise,

Code,

Code2

FROM

[Table.xlsx]

(ooxml, embedded labels);

//Where concat(Code=Replace(Code, Chr(6-7), ""), Code) //Error2- after semi colon in the previous line this doesn't work

Re: How to editing display text

mdmukramali — Thu, 22 May 2014 09:23:58 GMT

Dear,

I think your missing alias name.

Table:

LOAD [ID],

name as Name, // Missing alias name in our script

Group,

Weight,

prise,

Code,

Code2

FROM

[Table.xlsx]

(ooxml, embedded labels);

Where concat(Code=Replace(Code, Chr(6-7), ""), Code)

Re: How to editing display text

Thu, 22 May 2014 09:25:20 GMT

Thank you but it is not problem because I just make a mistake while copying.

Re: How to editing display text

Thu, 22 May 2014 09:28:08 GMT

Change it but still "code" fields don't merge and format how I need

Re: How to editing display text

Thu, 22 May 2014 09:40:08 GMT

Change everything what you say but program throw an error "Поле не найдено(Field didn't found) - <>"

Re: How to editing display text

mdmukramali — Thu, 22 May 2014 10:13:46 GMT

Dear,

can you share the sample file.

so that we can help you.

Thanks,

Mukram

Re: How to editing display text

crusader_ — Thu, 22 May 2014 10:26:35 GMT

Hi, Georgy

I don't think that understood your problem properly,

but what do you mean under

Where concat(Code=Replace(Code, Chr(6-7), ""), Code2)

expression?

If you want concatenate Code and Code2 fields,

you just need add

Code&Code2 as NewField

in your LOAD statement and there format your values.

If I understood you properly please reply or describe more your issue.

Andrei

Re: How to editing display text

Thu, 22 May 2014 10:34:59 GMT

I needed to remove symbols and merge fields.
Thank's a lot. I've realize it like that:

Table:
LOAD [ID],
      Name as Name1,
      Group,
      Weight,
      Price,
      Replace(Code, '::', '')&Code2 as Code
FROM
[Table.xlsx]
(ooxml, embedded labels);

and it works.

Re: How to editing display text

Thu, 22 May 2014 10:36:20 GMT

Thank you. I have already done.