topic Dual Function in QlikView

Dual Function

Wed, 25 Nov 2020 16:16:04 GMT

Dual (

Country & '-' &

Num(Sum(sales), '#,##0') &

Repeat(chr(13)&chr(10), rank(sum(sales)) -6),

sum(sales)

)

Plzz explain me this expression m not getting what is happening within this expression.

Thanks & Regards,

Qliker

Re: Dual Function

Thu, 28 Jul 2016 13:53:40 GMT

the function dual recive 2 values. 1 number (used on all calculations) 1 text(used only for show information for user).

in this case if you use a pie chart. show de sum of country, the reapt dont make number stway thogeder...

Re: Dual Function

Anil_Babu_Samineni — Thu, 28 Jul 2016 14:10:54 GMT

=Dual (

Country & '-' &

Num(Sum(sales), '#,##0') &

Repeat(chr(13)&chr(10), rank(sum(sales)) -6),

sum(sales)

)

As i understand, This requirement is for Calculate the Rank - 6 for Sales(If current Rank is 10, Requirement need 4th Rank)

Repeat function is repeated values. Here, Chr(13) is Spaces and Chr(10) is Next line

Might be Clear