Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

maxgro
MVP
MVP

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
Author

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
Partner - Creator
Partner - Creator

Hello,

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

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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)