Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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,

...

...

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

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,

View solution in original post

4 Replies
Highlighted
Specialist II
Specialist II

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,

View solution in original post

Highlighted
Contributor III
Contributor III

Ooo Yes,

thank you very much.

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

Highlighted
Contributor III
Contributor III

It´s Monday....

Highlighted
Specialist II
Specialist II

..

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

Force ‒ QlikView