Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
can you attach Sample QVW file.
Thanks,
Mukram
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))