topic Re: Remove Certain Values from Bar Chart in QlikView

Remove Certain Values from Bar Chart

markecirillo — Wed, 25 Nov 2020 16:16:04 GMT

I am brand new to Qlik and started by importing an Excel sheet I already had prepared. For this dimension "Business" I only want to see the first three values ("Ed," "PD" and "PL") on the chart and suppress the rest. In addition if the value "School" were to show up in the results I would want to include that as well. How do I do this?

Re: Remove Certain Values from Bar Chart

johnca — Mon, 18 Jun 2018 16:12:29 GMT

I suspect you are using a simple Sum(Value) expression. You can alter it to this;

Sum({<Business = {'Ed','PD','PL','School'}>}Value)

By using set analysis "{<Business = {'Ed','PD','PL','School'}>}" it will filter only those entries for Business.

hth,

John

Re: Remove Certain Values from Bar Chart

Chanty4u — Mon, 18 Jun 2018 16:37:06 GMT

As John try this Sum({<Business = {'Ed','PD','PL','School'}>}Value)

read this too

Excluding values in Set Analysis

Re: Remove Certain Values from Bar Chart

markecirillo — Mon, 18 Jun 2018 16:52:02 GMT

Thanks for the quick replies. As I said I am brand new to Qlik so I'm not sure where these expressions should go. Here is a screenshot of the entire sheet. Thanks.

Re: Remove Certain Values from Bar Chart

Chanty4u — Mon, 18 Jun 2018 17:08:36 GMT

try this right side below measure tab [instead of count(ISBN13) ] write below expression there

Count({<Business = {'Ed','PD','PL','School'}>}ISBN13)

Re: Remove Certain Values from Bar Chart

johnca — Mon, 18 Jun 2018 17:24:24 GMT

Although I don't use QlikSense the expression is correct (short your "Value" measurement "ISBN13". As Mark said enter the expression into the Expression section under Measures.

Next time post this in QlikSense forum. This forum is for QlikView.

Re: Remove Certain Values from Bar Chart

johnca — Mon, 18 Jun 2018 17:27:52 GMT

Oops...I meant as Chanty said. When folks reply to their own messages I sometimes get confused.

Re: Remove Certain Values from Bar Chart

Chanty4u — Mon, 18 Jun 2018 17:29:16 GMT

cool it happens sometimes

Re: Remove Certain Values from Bar Chart

markecirillo — Mon, 18 Jun 2018 18:41:19 GMT

That seems to do the trick. I had been putting the expression under dimensions! Also, thanks for the reference to the Qlik Sense forum. I will post there for any follow-ups. Thanks again for all the help.

Re: Remove Certain Values from Bar Chart

carolinarodrigues — Thu, 05 Jan 2023 20:09:09 GMT

But what if I just want to exclude one column? What expression should I use to consider everything else excluding a specific column?