dual() function

Tue, 26 Feb 2013 16:01:42 GMT

Hi,

Use of Dual() function?

please give me example............

Re: dual() function

Tue, 26 Feb 2013 16:19:21 GMT

From the Reference File:

dual(

s , x )

Forced association of an arbitrary string representations with a given number representation

x. In QlikView, when several pieces of data read into one field have different string representations but the same valid number representation, they will all share the first string representation encountered. The dual function is typically used early in the script, before other data is read into the field concerned, in order to create that first string representation, which will be shown in list boxes etc.

Example:

load dual(string,numrep) as DayOfWeek

inline [string,numrep

Monday,0

Tuesday,1

Wednesday,2

Thursday,3

Friday,4

Saturday,5

Sunday,6];

load Date, weekday(Date) as DayOfWeek from

afile.csv;

The script example will generate a field

DayOfWeek with the weekdays written in clear text. QlikView will for all purposes regard the

field as a numeric field.

Re: dual() function

techvarun — Wed, 10 Jul 2013 07:40:08 GMT

need some simple example

Re: dual() function

peschu123 — Wed, 10 Jul 2013 08:35:03 GMT

Take a look here:

http://www.qlikviewaddict.com/2012/12/the-qlikview-dual-function.html

and here:

http://www.learnqlickview.com/dual-function-in-qlikview/

"dual function qlikview" in google

topic Re: dual() function in QlikView

dual() function

Re: dual() function

Re: dual() function

Re: dual() function