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, '',
Basically, I need to say :
if the profit is equal to or less than $5, exclude