6 Replies Latest reply: Nov 25, 2016 4:27 AM by Trapti Gaharwar RSS

    Conditional Formating in Qlikview

    Trapti Gaharwar

      Hi,

      here find the attached excel of conditional formating in which i have Net of PE with the previous day.

       

      formula is as:

      If Net of PE of 1st jan would be greater than 31st dec so it would be green and if less than then it would be red.

       

      How do i give same condition in Qlikview.

        

                      

      County31st Dec1st Jan2nd Jan3rd Jan4th Jan
      Billing PENet of PEBilling PENet of PEBilling PENet of PEBilling PENet of PEBilling PENet of PE
      BHANDARA2551524026323240263232402632324026322241
      CHANDA2551923626327236263272362632723626322241
      GONDIA2502023025828230258282302582823025822236
      GADCHIROLI2551923626327236263272362632723626322241
      NAGPUR260132472682124726821247268212472688260