Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

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

Creator
Creator

Thanks, it works finely.