Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arvind1494
Contributor III

Dual function

Dual function

Hi All,

Can some one Tell me where can i use Dual function in Scrip

Give me some Example script

Tags (1)
1 Solution

Accepted Solutions
kundan_sharma1
New Contributor III

Re: Dual function

Dual() combines a number and a string into a single record, such that the number representation of the record can be used for sorting and calculation purposes, while the string value can be used for display purposes

Syntax:

Dual(text, number)

Load dual ( NameDay,NumDay ) as DayOfWeek inline

[ NameDay,NumDay

Monday,0

Tuesday,1

Wednesday,2

Thursday,3

Friday,4

Saturday,5

Sunday,6 ];

The field DayOfWeek

can be used in a chart, as a dimension, for example.In a table with the week days are automatically sorted into their correct number sequence, instead of alphabetical order.

3 Replies
kundan_sharma1
New Contributor III

Re: Dual function

Dual() combines a number and a string into a single record, such that the number representation of the record can be used for sorting and calculation purposes, while the string value can be used for display purposes

Syntax:

Dual(text, number)

Load dual ( NameDay,NumDay ) as DayOfWeek inline

[ NameDay,NumDay

Monday,0

Tuesday,1

Wednesday,2

Thursday,3

Friday,4

Saturday,5

Sunday,6 ];

The field DayOfWeek

can be used in a chart, as a dimension, for example.In a table with the week days are automatically sorted into their correct number sequence, instead of alphabetical order.

abhijith862
New Contributor III

Re: Dual function

Refer the Link for the same:

How to use- Dual()

d_ankusha
Contributor II

Re: Dual function

The Dual function is used to keep values in order.

For example:

Load Dual(day,number) Inline[

day,number

monday,1

tuesday,4

wednesday,2

];

OUTPUT:

monday

wednesday

tuesday

here you can see that the days are arranged in sorted order based on the number field.