Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Image expression

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..

6 Replies
Not applicable

Are you able to upload the sample application?

bindu_apte
Creator III
Creator III

Hi,

Can you please share the bundle load script which you are using.

mightyqlikers
Creator III
Creator III

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

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
nareshthavidishetty
Creator III
Creator III
Author

Thanks..

Can we change the arrow colour from default 'qmem://<bundled>/BuiltIn/arrow_s_r.png' iamege colour to any RGB.

Thanks..

Not applicable