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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select Differente Values in a Dimension of a Pivot Table

Hi I have a Pivot table which shows the results of the sales of my company. Currently I only have one dimension (Product) so the Table shows the sales by product of all the customers with no distinction at all. My intention is to create another table, similar to this one, but adding a new dimension (Customer Code). And i want it to display the result of only three customers (Let's say: CNA001, CNA002 and CNA003). I dont want to write a different script to this table reducing the customers. So how should I set the dimension? Is there any function similar to an array that let me do something like that:

Management.CustomerCode = function('CNA001',CNA002','CNA003)

I alsa must say that I don´t want to place a external selection field in the same sheet. This customers are always the same so I don't want to have to choose everytime.

Hope anybody can help me. Thanks a lot.

1 Solution

Accepted Solutions
john_duffy
Partner - Creator III
Partner - Creator III

Hello.

You could use a calculated dimension for CustomerCode. For example if(CustomerCode = 'CNA001' or CustomerCode = 'CNA002' or CustomerCode = 'CNA003',CustomerCode).

View solution in original post

2 Replies
john_duffy
Partner - Creator III
Partner - Creator III

Hello.

You could use a calculated dimension for CustomerCode. For example if(CustomerCode = 'CNA001' or CustomerCode = 'CNA002' or CustomerCode = 'CNA003',CustomerCode).

Not applicable
Author

It works!! Thanks a lot!!