How to click on a cell in a pivot table to filter data
In Qlik Sense I have a pivot table with 4 dimensions (3 fields and one month field) and one measure. The users want to be able to do the same as in a pivot table in excel which means they want to be able to click on a cell that will then open a new sheet with the detailed numbers of the amount displayed in the selected cell.
As I understand it, In a classic pivot table one cannot select cells but in the P&L pivot table (Qlik Visualization bundle) it is allowed. My issue is that there is a maximun of two dimensions allowed.
How can I allow the P&L pivot to have more than two dimensions ? Or is there another workaround possible ?
