Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dimitri_obrant
Contributor

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
MVP
MVP

Re: numeric value from dual field in Resident command

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
2 Replies
MVP
MVP

Re: numeric value from dual field in Resident command

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
dimitri_obrant
Contributor

Re: numeric value from dual field in Resident command

Thanks, it works finely.

Community Browser