Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to do the following in Qlik Sense. I am wondering if there is a way to do it using a pivot table. Alternatively, I can produce a straight table, and do the same operation. But I'd prefer to use pivot table to do it. Thanks!
I created a pivot table using like table 1
Table 1
|
Now I want to filter on product C so that only show rows where sales for C is greater than 0. I want the product selection to be user defined. i.e. If the user select product A, then we would filter on A using the same condition.
Table 2
|
If I understood you correctly, my original data is "organised" with one product column and a value column (sales). What I am showing in the original post is a pivot table I created in Qlik Sense based on the original data. The structure of the original data is like the following:
Client ID | Region | Product | Sales |
1 | North | A | 1000 |
2 | North | B | 500 |
3 | East | C | 100 |
4 | East | B | 1000 |
5 | Sourth | A | 500 |
6 | Sourth | C | 200 |
7 | West | A | 300 |
Not exact number as shown in the original post, but this shows the structure.
Client ID | Region | Product | Sales |
1 | North | A | 1000 |
2 | North | B | 500 |
3 | East | C | 100 |
4 | East | B | 1000 |
5 | South | A | 500 |
6 | South | C | 200 |
7 | West | A | 300 |
no need for the crosstable load so; just do as I've told u at first and tell me what happens
May be this:
Sum({<Product={"=Sum(Sales)>0"},Region={"$(=GetFieldSelections(Region))"}>}Sales)
Here we have to filters that will be done:
Region and Product
Here is the result:
Sum({<Region={'North','West'}>}Sales)
result: