Pivot Table - Top 3 WeekDays

[bhavvibudagam]

Hi,

In a Pivot Table I have added  Type,Weekday(Sun,Mon,Tue...) as Dimensions and Count(Events) As "Expression".

Now my requirement is have to display Top3 Weekdays as "Green Color" and Remaining weekdays as "Blue color".

Can any one please help me to do.

Thanks.

[Kushal_Chawda]

Top 3 based on what?

[migueldelval]

Hi Bhavvi b,

Could you attach qvw file?

Thanks

[bhavvibudagam]

Based on Count(Events) If we take Grand Total then highest 3 values Related Days has to be displayed in green color

[marjan_it]

Hi

in dimension in background section you can add your script like this:

=if(Aggr(rank(count((Events))),Weekday<=3,RGB(0,255,0),RGB(0,255,255))

[qlikview979]

Hi Bhavvi,

Please share your QVW file.

Regards,

Mahesh.

[Kushal_Chawda]

Go to Dimension Tab of Pivot table-> click + on dimension WeekDays, put below expression background color

=if( Rank(Count( Total <WeekDay>Event),0,1) <=3, green(), blue())

[marjan_it]

and this is my sample!

[bhavvibudagam]

Hi Settu, i have tried your expression but it is showing like this. Wed is in Green color.But Mon,Tue and Thur has to displayed in Green Color.

This is the expression what i have used,

=if(aggr(count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>}EVENT_NUMBER),CALL_TYPE)>=Max(TOTAL <CDTS_WeekDay>Aggr(count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>}EVENT_NUMBER),CALL_TYPE),3),

RGB(155,187,89),RGB(149,179,215))

[bhavvibudagam]

Hi miguel,

It's very large file.Source is in Qvd.I have attached the screen shot below please see it once.