topic Re: colors in QlikView

colors

master_student — Mon, 29 Jan 2018 11:19:50 GMT

Hello Guys

I have a calculated dimension. I would like to assigna color accordind to the result of this dimension

=Aggr(

If( Sum(TOTAL <[Code Cas],Code,[Concern. MSISDN],DAFERM,segment,[Spécialité Cas ],

[Criticité cas],[Détail Cas]>

num#(Interval(Interval#(SLA_INTERM, 's'), 'm'))) >

if (

ser ='BO TECKNO ' and [Criticité cas]='Critique' or [Criticité cas]='Non Critique' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

or segment ='LowEndUser'

or segment ='HighEndUser'

or segment ='Entreprise'

or segment ='One to one'

),1440

)

,'Hors Delais','dans les delais')

,[Code Cas],Code,[Concern. MSISDN],DAFERM,segment,[Spécialité Cas ],[Criticité cas],[Détail Cas])

,'Hors Delais' : red color

'dans les delais': Green Color

Thanks

Re: colors

mdmukramali — Mon, 29 Jan 2018 18:07:20 GMT

Hi,

can you attach Sample QVW file.

Thanks,

Mukram

Re: colors

evan_kurowski — Mon, 29 Jan 2018 20:29:22 GMT

Hello WEIM,

It looks like your syntax boils down to this:

=Aggr( IF( $(ConditionA) > $(ConditionB), Red(), Green()), [Insert_dimension_field(s)_here])

The end of the Aggr() function appears missing, you need to include the Aggr() dimension.

For the colors you can use QV static variables Red() & Green() or used RGB() function to create specific blends of red,green, blue ( i.e. RGB(100,255,100))