Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
claudialet
Contributor III
Contributor III

Display text and number values in expression ?

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 ?

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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!