Dual Function is not working

Anonymous — Thu, 07 May 2015 11:48:19 GMT

Hi all,

I used dual function like following

=Dual(Channel & '(' & num(Sum(Profitability)/1000,'#.#0%')& ')',num(Sum(Profitability)/1000,'$#,##0 K;($#,##0 K)'))

i got only (175695080.00%) value but i want % value as well as second expression value

Please help me

thanks,

Re: Dual Function is not working

Peter_Cammaert — Thu, 07 May 2015 12:00:55 GMT

The dual() function can be used to fill both the numerical part and the string representation of a value/field in QV memory. You cannot use it to concatenate strings, it that is what you want.

Use this to provide custom formatting for your expression results:

=Only(Channel) & '(' & num(Sum(Profitability)/1000,'#.#0%')& ')' & ' ' & num(Sum(Profitability)/1000,'$#,##0 K;($#,##0 K)')

topic Re: Dual Function is not working in QlikView

Dual Function is not working

Re: Dual Function is not working