Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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.

6 Replies
Not applicable

Re: How do I filter data for my sheet based upon a dimension?

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

MVP
MVP

Re: How do I filter data for my sheet based upon a dimension?

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)

1.png

Not applicable

Re: How do I filter data for my sheet based upon a dimension?

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
New Contributor III

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

Hello,

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

phaneendra_kunc
Valued Contributor III

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

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
Honored Contributor III

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

You may use calculated dimension as -

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

Community Browser