6 Replies Latest reply: Mar 14, 2015 7:46 AM by Fred Schonenberg RSS

    Conditional Formatting in Qlikview

      Hi Team,


      I am new to the Qlik community and this is my first post,also i am new to Qlikview and learning . please help !!


      Need help on Conditional formatting (Color Coding) in Qlikview QVW.


      I have a Chart (Pivot Table) in my QVW with some expressions. For example my Expression is "Expression_1" which is a value. now i have a target for this expression lets say the target is "1", now i want to get a color code(Green or Red) with respect to the target.


      I can use Visual Cues to achive what i need above BUT,


      My targets differ with each Dimension, Please find Example Below.

      Now i tried using If function in "Background Color" under "Expression_1" and was able to get Color  for first condition as below

      =if(Dimension_1='A' and Dimension_2='B' and Dimension_3='C' and Expression_1>=1,Green(),red())


      But what i want to know is HOW i can apply all conditions in one formula and get the color coding.


      Your Help is much appreciated, thanks a TON in advance !!