topic Re: Dimension selection in QlikView

Dimension selection

Wed, 25 Nov 2020 16:16:04 GMT

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

sunny_talwar — Fri, 03 Mar 2017 17:39:33 GMT

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 — Sun, 05 Mar 2017 07:38:50 GMT

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.

Mon, 06 Mar 2017 13:33:02 GMT

thank you very much!!