Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
subin6600
Creator III
Creator III

Straight table cell coloring and total issue- Help me here!

I have a straight table which needs to show the assignment days for a person monthly with data having weekly.

i.e, the data as shown below.

yearstatusNameWeekmandaysMonthAssgn
2011approvedSubin112Marsocial
2011approvedSubin113Marscience
2011newThomas114Marscience
2011newThomas121Marsocial
2011rejectedgeorge122Marenglish
2011newgeorge123Marenglish
2011rejectedthomas124Marenglish
2011newsubin132Aprmaths
2011approvedthomas135Aprmaths
2011newgeorge133Aprmaths
2011rejectedgeorge133Aprenglish
2011newgeorge142Aprenglish

PFA Qlikview document where i need to color code based on the status as in here i have New in Red, Approved in Green and rejected in blue.

Requirement: I want to have the total based on a person for each month as shown in the qv file. And the total value cell should not have any colors.

Could any one please help me here.

Regards,

Subin Thomas

3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

check the attch file

i use dimensionality() in the background formula

subin6600
Creator III
Creator III
Author

I got the row to be in the correct format but could i get it in the column as well??

Thanks for the immediate reponse Liron.

subin6600
Creator III
Creator III
Author

.