topic Re: How to Exclude Certain Values in a Chart in QlikView

How to Exclude Certain Values in a Chart

Wed, 13 Apr 2016 15:42:12 GMT

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!

Re: How to Exclude Certain Values in a Chart

Chanty4u — Wed, 13 Apr 2016 16:01:51 GMT

chk dis

https://community.qlik.com/blogs/qlikviewdesignblog/2015/10/19/excluding-values-in-set-analysis

Re: How to Exclude Certain Values in a Chart

sunny_talwar — Wed, 13 Apr 2016 16:03:42 GMT

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.

Re: How to Exclude Certain Values in a Chart

Wed, 13 Apr 2016 18:35:59 GMT

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

Re: How to Exclude Certain Values in a Chart

Wed, 13 Apr 2016 18:36:15 GMT

Thanks for the help!