Set Analysis and Back ground Color exp should act same way

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

Hi Experts.. This is bit tricky and am not able to find it.. Hope it will be simple for u guys..

Here is the scenario..

My Expression is

sum({<Date = , Month = ,AGED_DAYS_SUMMARY_ID -= {'[6] NO RECEIPT'}>}USD_INV_DOLLARS)/1000000

In the above expression, i have included ("Date = , Month = ").. So now i get the output accordingly..i.e., if i select Date or month, i dont see it is getting reflected in my chart...

Next is i have added Background color expression also... it is like below

if (Aging_Bucket1 = '>365' , RGB(255,0,0),

if (Aging_Bucket1 = '181-365', RGB(250,70,70),

if (Aging_Bucket1 = '91-180', RGB(252,115,98),

if (Aging_Bucket = '>90' , RGB(255,0,0),

if (Aging_Bucket1 = '61-90' or Aging_Bucket = '61-90', RGB(255,255,0),

if (Aging_Bucket1 = '31-60' or Aging_Bucket = '31-60', RGB(77,167,65),

if (Aging_Bucket1 = '0-30' or Aging_Bucket = '0-30', RGB(77,200,65))))))))

Now the issue is... in my dashboard, i have a default date selection to the latest date.. in my chart i have date as dimension.. since latest date is selected.. only for the latest date, the above color coding works.. i need this to apply the color coding expression for all the bars irrespective of if the latest date is been selected.. How do i now apply the same logic which i used in my expression ("Date = , Month = ") in my background color expression as well??

he is how i see the chart now..

Below snapshot week will be selected by default in my dashboard

Re: Set Analysis and Back ground Color exp should act same way

tresB — Fri, 08 Sep 2017 06:04:04 GMT

Try putting only() around your expression like:

Only( {<Date, Month>} Your expression )

Re: Set Analysis and Back ground Color exp should act same way

bharani8 — Fri, 08 Sep 2017 06:11:41 GMT

Perfect!! good to know how to use Only() TY!!

topic Re: Set Analysis and Back ground Color exp should act same way in QlikView

Set Analysis and Back ground Color exp should act same way

Re: Set Analysis and Back ground Color exp should act same way

Re: Set Analysis and Back ground Color exp should act same way