Choice of specific dimension in list box does not create result via link to straight table
I have build a report in QV, where I have a number of list boxes on the left side of the screen and three different charts (a straight table, a bar chart and a text box) on the right side of the screen. The list boxes are for the users to make different choices and the results are then shown in the charts. In the charts I have limited the results shown via a set analysis.
When I choose a value for two specific dimensions in two of the list boxes, the corresponding results are not shown in the charts. It only happens with the choice of the two specific dimensions that are being limited via set analysis, not the other dimensions that the users can choose in the other list boxes.
Does anyone have an idea what to do? I suspect I need to change the set analysis. My set analysis looks like this:
Let med try to elaborate. My dataset consists of a number of public procurement data from all kinds of different countries. In the list boxes on the left, I can make different choices, e.g. Name of City, Name of country, Name of supplier, Winner of contract etc.
I want my charts to show all results but limited to results from the four scandinavian countries (= country codes: SE, FI, DK, NO). One of the dimensions that I limit via set analysis is thus the dimension country code, which I have limited like this:
However, when I choose only one of the countries in my list box - e.g. DK - I only want to see results for DK, but the chart still shows results from all four countries.