Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

colors

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 ='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

2 Replies
mdmukramali
Specialist III
Specialist III

Hi,

can you attach Sample QVW file.

Thanks,

Mukram

evan_kurowski
Specialist
Specialist

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

community_thread_289370.png