How do I filter data for my sheet based upon a dimension? (In Qlik Sense)

[#1]

I have a table called Catalog for example.  There is a column called Company and I wanted to filter out the Company so that only one displays.

Company

A Suit

B Jam

C Taylor

I want the sheet to only list data related to A Suit only.

Kind of hard to get a quick answer with the documentation I have been able to find.

In Sequel, I would just use Company = 'A Suit'  and that would filter my data.

[#2]

Looking for the syntax, cannot find a good example anywhere.

[maxgro]

If you want all the charts in the sheet to only show the "A Suit" company you can add at the sheet level 2 trigger (actions)

[#4]

How would I do this with Qlik Sense?

I have my data, I added the dimension, I then opened up the expression editor.

I just want to only show data in the table related to one particular company only.

In sequel it is an easy statement:  company = 'ACME Pest Control'

I am trying to understand the syntax within Qlik Sense.

Thanks for the reply.  Qlik View is easier in this sense.

[harishicon]

Hello,

U can use the calculated dimension to show only one value. Otherwise  tick on "one selected always " in filter.

[phaneendra_kunc]

Lets say you are trying to show Sales for Company ACME Pest Control, you can write your expression like this.

Sum({<Company = {'ACME Pest Control'}>}Sales)

[Digvijay_Singh]

You may use calculated dimension as -

=if(Company='A Suit',Company)