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: 
Not applicable

Dimension selection

hello

I am new to qlik.

I have got an excel sheet with:

     - a column titled "Product", containing different product types (e.g. Prod A, Prod B, Prod C, Prod D).

     - a column titled "sales" containing numbers of sales corresponding to that products

How to display into a qlik  a pivot table with only some selected product tipes (for example only Prod A and Prod B)?

I would like to have product types on the rows and sales on the column.

sorry for the basic question

thank you

Jessica

3 Replies
sunny_talwar

You can use  set analysis in your sales expression. Assuming you do Sum(Sales), you can do like this

Sum({<Product = {'Prod A', 'Prod B'}>}Sales)

Alternatively, you can restrict your dimension using an if statement

If(Match(Product, 'Prod A', 'Prod B'), Product)

Anonymous
Not applicable
Author

hi jessica,

heres a qvw to further elaborate on what sunny has mention. for dimension you can use product, expression just use what sunny has mentioned.

Not applicable
Author

thank you very much!!