expression symbol

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

Hi,

I have used the #,##0.0% ▲; #,##0.0%▼ as number format to give symbols to my expression based on some color condition.

But I'm getting the results as below,

We are getting the same up triangle for both the conditions.

logic used:

sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Date Extract]={'>$(=AddMonths(max([Date Extract]),-6))<=$(=AddMonths(max([Date Extract]),-5))'}, [QN Age 30+ Days]={1}>} [# Open]) /

sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Date Extract]={'>$(=AddMonths(max([Date Extract]),-6))<=$(=AddMonths(max([Date Extract]),-5))'}>}[# Open])) *100

Thanks..

Re: expression symbol

lironbaram — Mon, 30 Jul 2018 09:01:45 GMT

the number format #,##0.0% ▲; #,##0.0%▼

specifics what is the format for positive and negative values , as both of your number are positive

you get the same number format ,

you can use num function in your expression to change the format according to your conditon

for example

if(EXPRESSION > 50 , num(EXPRESSION, '#,##0.0% ▲'),num(EXPRESSION, '#,##0.0% ▼'))

topic expression symbol in QlikView

expression symbol

Re: expression symbol