topic Excluding a selection within a field from a chart in QlikView

Excluding a selection within a field from a chart

Wed, 02 Jul 2014 15:08:26 GMT

Hi, I'm trying to exclude a selection with a field in a chart. At the moment I have Inbound>5,4,3,2,1 and outbound within the field inbound, I can't remove the outbound in the data set and I'm trying to create a chart that has inbound>5,4,3,2,1. I.e I want to exclude outbound from the chart as the figures are larger than inbound skewing the chart greatly. Any ideas?

Re: Excluding a selection within a field from a chart

vgutkovsky — Wed, 02 Jul 2014 15:57:30 GMT

Use set analysis in your expressions. In general, I'd recommend that you take a look under Set Analysis in the QV Desktop help file as it is an excellent article. In your case, if your expression is sum(Sales) for example, you could write: sum({<inbound={">=1<=5"}>}Sales)

Regards,

Vlad