Discussion board where members can learn more about Qlik Sense App Development and Usage.
I used the pivot table chart to create the confusion matrix with the following data structure:
Now I've a dimension that i would like to filter the data by and the dimension is year. I've another table that contains the documents details with the following structure:
However, when i inserted year as a dimension into a filter pane, it only filters the x dimension in the pivot table. (as expected)
An example is if i select 2017 in the year filter pane, the pivot table will show Doc A and Doc B on the row but still show Doc A, Doc B and Doc C on the column in the pivot table.
Is there any way i could select a value in the year filter pane and filter for both x and y in the pivot table?