Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
janturon
New Contributor III

Field Not Found When Converting Field to Text()

Hi,

I need to convert field hk_US to text, because QlikView automaticly takes this field (when is without cast...) as Num and makes TOTALS which I dont want. For example If values are 31 and 031, Qlik merge this values to 031.

I used script like below... But always have Error code Field not found.

P.S. Select is from ORACLE

TABLE:

LOAD

  Text (hk_US) as hk_USyn,

$(vminobd) as OBDOBIE,

    *;

SQL

SELECT

UCTY.ID,

cast (UCTY.UCET as varchar(10)) as hk_US,

...

...

Tags (2)
1 Solution

Accepted Solutions
zhadrakas
Valued Contributor

Re: Field Not Found When Converting Field to Text()

try in upper case

TABLE:

LOAD

  Text (HK_US) as hk_USyn,

$(vminobd) as OBDOBIE,

    *;

SQL

SELECT

UCTY.ID,

cast (UCTY.UCET as varchar(10)) as hk_US,

4 Replies
zhadrakas
Valued Contributor

Re: Field Not Found When Converting Field to Text()

try in upper case

TABLE:

LOAD

  Text (HK_US) as hk_USyn,

$(vminobd) as OBDOBIE,

    *;

SQL

SELECT

UCTY.ID,

cast (UCTY.UCET as varchar(10)) as hk_US,

janturon
New Contributor III

Re: Field Not Found When Converting Field to Text()

Ooo Yes,

thank you very much.

I forgot that ORACLE always names fields with UPPER CASE signs.

janturon
New Contributor III

Re: Field Not Found When Converting Field to Text()

It´s Monday....

zhadrakas
Valued Contributor

Re: Field Not Found When Converting Field to Text()

..

you can override this Setting with the force function if needed.

Force ‒ QlikView