Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is different function of Dual and Mode?

What is function of Dual in Qlikview? Can someone help me to explain?

Thanks

1 Solution

Accepted Solutions
its_anandrjs

Hi,

It is used to concatenate two fileds into on field basiscally and make single field comes up with two field.

syntax is dual(field1,field2) as newfield

Regards,

Anand

View solution in original post

4 Replies
its_anandrjs

Hi,

It is used to concatenate two fileds into on field basiscally and make single field comes up with two field.

syntax is dual(field1,field2) as newfield

Regards,

Anand

Not applicable
Author

What is the different with function Mode? May be someone can give me the example of different dual and mode function. Thanks

its_anandrjs

Hi,

Example of Dual

load dual(String,Num) as DayOfWeek inline

[String,Num

Mon,0

Tue,1

Wed,2

Thu,3

Fri,4

Sat,5

Sun,6

];

Example of Mode

Mode is a aggregation function

load

Month,

mode(feild) as CommanNumber

from SourceFile

Group by Month;

HTH

Regards,

Anand

SunilChauhan
Champion II
Champion II

dual function can keep two values at a time.

example

dual(a,b) it will hold two valuees i.e a and b values

a should be text and b should be integar

and

mod function

mod(x1 , x2)

Mathematical modula function. Both parameters must have integer values. x2 must be greater than 0. The result is the non-negative remainder of an integer division.

Examples:

mod( 7,2 ) returns 1

mod( 7.5,2 ) returns NULL

mod( 9,3 ) returns 0

mod( -4,3 ) returns 2

mod( 4,-3 ) returns NULL

mod( -4,-3 ) returns NULL

hope this helps

Sunil Chauhan