topic Re: Conditional color expression in QlikView

Conditional color expression

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

I have below script and would like to add a condition that if output is 'M' I need to color with RGB(291,191,0)

=if(aggr( Concat( DISTINCT if([ALL.alg-code]='SO2',if([ALL.qual-code]='M','M',if([ALL.alg-stat]='N','N',if([ALL.alg-stat]='Y','Y',))),null()),'-'),[p-code],[PRODUCTS.p-desc],[PRODUCTS.p-size],PRODUCTS.origin)='Y',RGB(255,0,0),'')

Re: Conditional color expression

buzzy996 — Fri, 02 Feb 2018 11:22:06 GMT

pfa,try to repalce the same expression on backgroubd definition & see or work around.

Re: Conditional color expression

dmxmikey — Fri, 02 Feb 2018 11:58:38 GMT

I need a multiple condition script

Re: Conditional color expression

sunny_talwar — Fri, 02 Feb 2018 12:50:56 GMT

May be this

Pick(Match(Aggr(Concat(DISTINCT

If([ALL.alg-code] = 'SO2',

If([ALL.qual-code] = 'M', 'M',

If([ALL.alg-stat] = 'N', 'N',

If([ALL.alg-stat] = 'Y', 'Y',))), null()), '-'),

[p-code], [PRODUCTS.p-desc], [PRODUCTS.p-size], PRODUCTS.origin), 'Y', 'M'), RGB(255,0,0), RGB(291,191,0))