Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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!

Community Browser