Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to show only a subset of records in a straight table

I have a table like this

YearDeptAward
2011Finance3
2011HR2
2011HR2
2011Sales2
2012Finance2
2012Finance2
2012HR2
2012Sales1
2012Sales2
2012Finance1

I am trying to setup dashboard for different department.

How do I display a table that shows only data for specific group, e.g. only Sales data using Set Analysis?

YearDeptAward
2011Sales2
2012Sales1
2012Sales2
10 Replies
Anonymous
Not applicable
Author

Thanks everyone for the answers !