Display text and number values in expression ?

[claudialet]

Here is my expression

If(Dimensionality()=1 and TotalsFlag=1,'',

 num(if( Level2 = 'FX Rate ',   if($(vFilter)= 4,  FXRate,  ValueAmount) ,

sum(distinct(ValueAmount *PercentOwned) *if($(vFilter)= 4,ConversionFactor,1))) ,

if( LineDescription2 = 'FX Rate ' , '#,##0.00000;(#,##0.00000)', '#,##0;(#,##0)' )) )

if (Dimensionality ()=1 and DescriptionLevel1 = 'Currency',  CurrencyCode

The last line should display 'Currency' row with letter values.  Is it possible to incorporate this in same expression ?

[Oleg_Troyansky]

Hi,

the short answer is "yes, it's possible" - you can concatenate numbers and strings, or you can include strings in your numeric format.

As a side comment, it appears to me that your formula might be unnecessarily complex. I have a feeling that there should be a simpler way of achieving the same, but it's hard for me to assess, without seeing it in the context of your application.

Cheers,

Oleg Troyansky

Upgrade your QlikView and Qlik Sense knowledge at the Masters Summit for Qlik - coming to Stockholm this April!