3 Replies Latest reply: Apr 24, 2012 5:19 AM by Subin Thomas RSS

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

    Subin Thomas

      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