Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
dimitri_obrant
Creator
Creator

numeric value from dual field in Resident command

Hello,

in my script I create some tables with Dual fields. Later in the same script I read the tables with a Resident command and need only numeric values from Dual fields. Which syntax is correct?

For example

Load dualfield

Resident Table

The result is text value but it has to be a numeric value.

1 Solution

Accepted Solutions
jonathandienst

Hi

This will load the numeric value:

Load Num(dualfield) As numfield

Resident Table

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst

Hi

This will load the numeric value:

Load Num(dualfield) As numfield

Resident Table

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

dimitri_obrant
Creator
Creator

Thanks, it works finely.