Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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

.