Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

Pivot Table - Top 3 WeekDays

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.

1 Solution

Accepted Solutions
sunny_talwar

May be this:

=If(Sum(Aggr(Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>} EVENT_NUMBER), CDTS_WeekDay))>= Max(TOTAL Aggr(Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'}>}EVENT_NUMBER), CDTS_WeekDay), 3), RGB(155,187,89),RGB(149,179,215))

View solution in original post

12 Replies
Kushal_Chawda

Top 3 based on what?

migueldelval
Specialist
Specialist

Hi Bhavvi b,

Could you attach qvw file?

Thanks

bhavvibudagam
Creator II
Creator II
Author

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

marjan_it
Creator III
Creator III

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

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
Creator III
Creator III

and this is my sample!

bhavvibudagam
Creator II
Creator II
Author

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
Creator II
Creator II
Author

Hi miguel,

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