Remove Certain Values from Bar Chart

[markecirillo]

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?

[johnca]

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

[Chanty4u]

hi

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

read this too

Excluding values in Set Analysis

[markecirillo]

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.

[Chanty4u]

Hi

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

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

[johnca]

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.

[johnca]

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

[Chanty4u]

cool it happens sometimes

[markecirillo]

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.

[carolinarodrigues]

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