Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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