Scattered Plot--How to remove empty values in a Trellis

[Abubakar anwar]

Hello to all Spotfire experts,

 

i am facing a situation that i have two set of variables which I have put in a Trellis in a scattered plot diagram in spotfire.

 

Now i have some filters which I use to identify how different set of criteria show different results. But there are empty labels in the graphs.

 

P.S i also have data limiting and I only want to see the top 5 results for each of the Trellis diagram.

 

I have attached a view in the query. On the left hand side you see that "PT" is visible but it has no value. its because "PT" has a value on the right hand side.

 

same for "JP".

 

Looking forward to your suggestions.

Best regards

[Richard Pobi]

Add thisexprssion to your data limit expression that will remove the zero values. I am guessing you already have expression limiting your data to Top 5. So and the below expression to it

AND ([Amount column])0

[Abubakar anwar]

Hi Richierich,

i tried using this before but it didn't work. I used AND ([Amount column]) is not null instead of your suggestion. I tried your suggestion and it also doesn't work.

 

I have values on the y-axis and countries list on x-axis.

 

Yes, I do not have an expresssion instead i have used show/hide feature in the properties. I think you mean the same. but that is also a bit annoying. in reality i would like to show top 10 but i cannot do so there.

 

Any further suggestions shall be highly appreciated.

 

Best,

[Richard Pobi]

If you did not use expression to limit your data then try this expression 

 

[Amount col]<>0

 

 Properties>Data> limit data using expression Edit> [Amount col]<>0 > Ok

[Abubakar anwar]

I tried and it still doesn't work unfortunately.

[Richard Pobi]

You can show top 10 by select Custom Expression then type 10 from your Show/Hide Items properties

[Abubakar anwar]

thanks for that. but the initial problem is not yet solved. unfortunately

[Richard Pobi]

I think if you can share a dxp or sample data of what you are working with will help make things a bit easier for the community to help.

[Abubakar anwar]

I will create a sample data and share it with you.

 

that will definitely be easier. currently its too big for handle.the data i mean