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: 
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
1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

10 Replies
Clever_Anjos
Employee
Employee

Use only({<Dept={"Sales"}>}Award) as expression OR

Use aggr(only({<Dept={"Sales"}>Dept),Dept) as dimension and check "Supress when value is null"

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution, created one new ID field in script and add it as the dimension field.  Hidden this ID field in Straight table by using

Chart Properties -> Presentation -> Columns -> Select ID -> Select Hide Column

Hope this helps you.

Regards,

Jagan.

Anonymous
Not applicable
Author

Hi Clever Anjos

Thanks for the prompt reply.

I cant seem to get it to work.

See the attached file

Thanks

Anonymous
Not applicable
Author

Jagan,

I don't see the attachement

preminqlik
Specialist II
Specialist II

hi there,

use this expression sum({<Dept={'HR'}>}Award)

Regards

Prem

Clever_Anjos
Employee
Employee

Check this

jagan
Luminary Alumni
Luminary Alumni

pfa.

Anonymous
Not applicable
Author

Thanks.  I understand now.

Anonymous
Not applicable
Author

Thanks !