topic Re: Image expression in QlikView

Image expression

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

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

Re: Image expression

Mon, 04 Jul 2016 07:01:47 GMT

Are you able to upload the sample application?

Re: Image expression

bindu_apte — Mon, 04 Jul 2016 07:02:33 GMT

Hi,

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

Re: Image expression

mightyqlikers — Mon, 04 Jul 2016 07:20:01 GMT

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

Re: Image expression

Anil_Babu_Samineni — Mon, 04 Jul 2016 07:31:39 GMT

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

Re: Image expression

nareshthavidishetty — Mon, 04 Jul 2016 07:32:29 GMT

Thanks..

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

Thanks..

Re: Image expression

Mon, 04 Jul 2016 14:33:34 GMT

Use color pic

ColorPic, The Desktop ColorPicker Software