topic Re: [Removing a value from table] in QlikView

[Removing a value from table]

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: [Removing a value from table]

narendiran — Mon, 18 Jul 2016 16:14:15 GMT

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

Re: [Removing a value from table]

Gysbert_Wassenaar — Mon, 18 Jul 2016 16:14:43 GMT

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)

Re: [Removing a value from table]

Mon, 18 Jul 2016 16:51:12 GMT

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!

Re: [Removing a value from table]

susovan — Tue, 19 Jul 2016 10:04:04 GMT

Hi David,

You can also try this process,

Re: [Removing a value from table]

Mon, 25 Jul 2016 17:03:53 GMT

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.

Re: [Removing a value from table]

Gysbert_Wassenaar — Mon, 25 Jul 2016 17:29:04 GMT

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

Re: [Removing a value from table]

Mon, 25 Jul 2016 17:31:43 GMT

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