Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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.
thank you very much!!