topic Re: Display text and number values in expression ? in QlikView

Display text and number values in expression ?

claudialet — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: Display text and number values in expression ?

Oleg_Troyansky — Fri, 01 Feb 2019 23:04:42 GMT

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!