Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Looking for the syntax, cannot find a good example anywhere.
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)
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.
Hello,
U can use the calculated dimension to show only one value. Otherwise tick on "one selected always " in filter.
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)
You may use calculated dimension as -
=if(Company='A Suit',Company)