[Removing a value from table]

[#1]

Hi,

my sum aggregate table looks something like this

A 100

B 131

C 165

D 188

E 1000000000

The numbers next to the A,B,C,D,E are the frequencies of them.

so when I make them into any graphs E dominates the whole chart and it makes all the other values meaningless.

I want to remove E temporarily and make chart only with frequency value of A, B, C, D

How Can I do that?

Thank you in advance!!

David

[narendiran]

if A,B,C,D,E with a name Column1. =if (Column1 <> E, Column1) Or use set analysis. Hope this will help

[Gysbert_Wassenaar]

You can edit the script and add a where clause to exclude the value E and reload the document. Then when you're done remove the where clause and reload the document again. I don't recommend doing this. Instead use selections. First select E in a listbox and then right click that listbox and choose Select Excluded. You could create a bookmark for this selection for if you need it again. Or you can filter out E in a chart expression. Instead of sum(Amount) you can use sum({<MyField -= {'E'}>}Amount)

[#4]

Hi Narendiran,

Thank you for your reply.

Could you show me an example of how I can utilize set analysis? I know briefly what the set analysis is but I am not adapt at putting it into use yet.

Thank you!

[susovan]

Hi David,

You can also try this process,

[#6]

Hi everyone who answered my question.

Thank you all very much. I tried all the methods mentioned above and learned from those.

but I should have mentioned that  the last value with large amount of counts were actually "others" and by that it means NULL.

susovan.g‌ 's method could not be used since no matter what I do, the 'other' will stay in it.

gwassenaar‌'s method could not be used since Null values does not show up in list box

but i took a way around and did

"Show only values that are" "smaller than" "15%" and got the table that I was expecting to get.

but I know this is just a temporary fix.

It would be great if you guys could tell me how I should use set analysis for this.

Thank you for replying and thank you in advance for the follow up question also.

[Gysbert_Wassenaar · Accepted solution]

If you want to show results only for non-null values use sum({<MyField = {'*'}>}Amount)

[#8]

Thank you so much!!! I better get used to set analysis.