Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We were using straight table in which we have show up and down arrows as per the limits and we have used the image selector in expression tab and gave the below condition,
if(Sum(ESIGN_COMPLETE)/Sum(DAILY_TOTAL_CONTRACTS)>='70%','qmem://<bundled>/BuiltIn/arrow_n_g.png',if(Sum(ESIGN_COMPLETE)/Sum(DAILY_TOTAL_CONTRACTS)>='50%' and Sum(ESIGN_COMPLETE)/Sum(DAILY_TOTAL_CONTRACTS)<='69%','qmem://<bundled>/BuiltIn/arrow_n_r.png','qmem://<bundled>/BuiltIn/arrow_s_r.png'))
Here it shows only down arrow symbol and it not act with the as per limits.
Thanks..
Are you able to upload the sample application?
Hi,
Can you please share the bundle load script which you are using.
HI ,
try below.
if(Sum(ESIGN_COMPLETE)/Sum(DAILY_TOTAL_CONTRACTS)>='0.7','qmem://<bundled>/BuiltIn/arrow_n_g.png',if(Sum(ESIGN_COMPLETE)/Sum(DAILY_TOTAL_CONTRACTS)>='0.5' and Sum(ESIGN_COMPLETE)/Sum(DAILY_TOTAL_CONTRACTS)<='0.69','qmem://<bundled>/BuiltIn/arrow_n_r.png','qmem://<bundled>/BuiltIn/arrow_s_r.png'))
$@M
Like this,
Here, what is the action acting here, >=70% and second expression what do you want - >-50%
if(Sum(ESIGN_COMPLETE)/Sum(DAILY_TOTAL_CONTRACTS)>='70%','qmem://<bundled>/BuiltIn/arrow_n_g.png',if(Sum(ESIGN_COMPLETE)/Sum(DAILY_TOTAL_CONTRACTS) = {">='50%' " and "<='70%' "} and Sum(ESIGN_COMPLETE)/Sum(DAILY_TOTAL_CONTRACTS)<='69%','qmem://<bundled>/BuiltIn/arrow_n_r.png','qmem://<bundled>/BuiltIn/arrow_s_r.png'))
give me clarification?
1) You want to show Above 70% - Red
2) You want to show Above 50% - Green / You want to show between of 50% and 70% - Green
3) And Finally you want to show below 69% is Black
- Anil Chowdary
Thanks..
Can we change the arrow colour from default 'qmem://<bundled>/BuiltIn/arrow_s_r.png' iamege colour to any RGB.
Thanks..
Use color pic