how do I present a filtered dashboard table in qlik sense?
I built a dashboard in qlik sense and I am showing a table with clients and their orders from the beginning of the year until the end of the last month. that same table is a basis (DATA BASE) for all of my other computations in the dashboard. I want that specific table to output only order which have not been completed. How do I filter a table within the dashboard - NOT using the filter tab in the column header.
You can filter the object data by using Set Analysis. This way the object's data is filtered no matter what are the applied filters (on the field(s) in the set analysis)
If the measure is:
sum( {< OrderStatus = {'Completed'} >} Sales)
Then the dimensions will be filtered to show only values for which OrderStatus is Completed. And even if you select OrderStatus = NotCompleted (or there are no selections in OrderStatus field) then the table will still show only the Completed values
Update:
If the table shows only dimensions (without any aggregation) then you can "convert" the client dimension to measure and use set analysis there:
Only({< OrderStatus = {'Completed'} >} Client)
And keep the other column(s) as dimensions.
The Client column is now a measure with the following expression:
And you can see the difference between the tables (added OrderStatus column just for the test):
