Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

How to Exclude Certain Values in a Chart

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!

4 Replies
Chanty4u
Esteemed Contributor III

Re: How to Exclude Certain Values in a Chart

Re: How to Exclude Certain Values in a Chart

May be use set analysis:

{<Salesperson_JobProfit = {'>5<=1500'}>}

You can use any range (static or dynamic in your set analysis to get this done.

Not applicable

Re: How to Exclude Certain Values in a Chart

Thank you!! I was able to figure it out based on that video.

Not applicable

Re: How to Exclude Certain Values in a Chart

Thanks for the help!