topic Re: Dynamic Background Expression in QlikView

Dynamic Background Expression

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

Hi Community,

Following Table is in my database. Requirement is to not make hardcore value in background color Expression because it may change at any time.

My Expression is sum(Discount)/Sum(Amount)*100

How can i make background color Expression such a way that if any values in FROM_VALUE or TO_VALUE will change then there will be no need to change in Development side.

Should i make variable for column FROM_VALUE or TO_VALUE?

RAGSTATUS	FROM_VALUE	TO_VALUE
GREEN	0	5
AMBER	6	15
RED	16	100

Re: Dynamic Background Expression

Anonymous — Wed, 06 Apr 2016 10:38:12 GMT

Hi Satish,

try this

my code:

T1:

LOAD * INLINE [

Region, orderDate, Product, Amount

4, 1/4/2011, Case 4, 3

5, 1/5/2011, Case 5, 20

6, 1/4/2011, Case 4, 2

7, 1/5/2011, Case 5, 40

8, 1/2/2011, Case 5, 15

];

T2:

LOAD * INLINE [

RAGSTATUS, FROM_VALUE, TO_VALUE

GREEN, 0, 5

AMBER, 6, 15

RED, 16, 100

];

Dim:

orderDate

Exp:

sum(Amount)

background exp:

if(sum(Amount)>=Min(FROM_VALUE)and sum(Amount)<=min(TO_VALUE),rgb(154,205,50),

if(sum(Amount)>=Min(FROM_VALUE,2)and sum(Amount)<=min(TO_VALUE,2),rgb(255,165,0),rgb(255,0,0)))

output:

you just need to replace sum(Amount) with your exp sum(Discount)/Sum(Amount)*100

like:

if((sum(Discount)/Sum(Amount)*100)>=Min(FROM_VALUE)and (sum(Discount)/Sum(Amount)*100)<=min(TO_VALUE),rgb(154,205,50),

if((sum(Discount)/Sum(Amount)*100)>=Min(FROM_VALUE,2)and (sum(Discount)/Sum(Amount)*100)<=min(TO_VALUE,2),rgb(255,165,0),rgb(255,0,0)))

Regards,

Sandip Satbhai

Re: Dynamic Background Expression

Wed, 06 Apr 2016 12:10:56 GMT

Open the chart properties.
Go to Visual Cues tab.
Select the required expression, define the upper and lower limit and choose the desired color.