Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
a-5
Contributor III
Contributor III

Table to include the selected dimension values only based on another dimension

Hi,

I have the following dimensions in my data model:

Customer Customer type
Customer1 A
Customer2 B
Customer3 A
Customer4 C
Customer5 B
Customer6 A
Customer7 A
Customer8 C

 

I want to create a table in my app including customers with customer type A only:

Customer
Customer1
Customer3
Customer6
Customer7

 

How can I create such a customer list including customer with type A only?

I do not want to show customer type in the table and also I do not want to create a bookmark with customer type filtering the entire sheet (because other customer types are shown in other charts/tables in the same sheet). 

Thank you for your assistance! 

 

Labels (4)
1 Solution

Accepted Solutions
Gabbar
Specialist
Specialist

aggr(Only({<CustomerType={'A'}>}Customer),Customer)

View solution in original post

2 Replies
Gabbar
Specialist
Specialist

aggr(Only({<CustomerType={'A'}>}Customer),Customer)

Mark_Little
Luminary
Luminary

I would create the dimension in Script.

 IF([Customer Type] = 'A', Customer) AS [A Customers]