4 Replies Latest reply: Apr 13, 2016 2:35 PM by Angela Perez RSS

    How to Exclude Certain Values in a Chart

    Angela Perez

      Hello all,

       

      I am new to Qlikview scripting. Currently I'm working on a project with some datasets that must be loaded and displayed on screen. My task is to create a chart that excludes certain values. Here's an example of what I'm talking about.

       

      Salesperson A has a job whose profit is worth $1500 (Salesperson_JobProfit). I want to include him in the chart.

      Salesperson B has a job whose profit is worth $5 (Salesperson_JobProfit). I need to exclude him from the chart.

       

      How would I be able to do that? I need to make sure that the $5 jobs are not entirely excluded from the data set (I still need them to be included as accessible data), but I don't want to include them in my chart. Can I use a conditional value? I was thinking something like:

      if(Salesperson_JobProfit <= 5, '',

      Salesperson_JobProfit)

       

      Basically, I need to say :

      if the profit is equal to or less than $5, exclude

      else, include

       

      Any help is appreciated!