Hello, I have an issue to resolve regarding Qlik Sense. I have a dashboard where I have a filter 'Type of Statistic' that filters by type of statistics, such as sold, revenue, etc. So, when this filter is set, it selects the documents from which it should take the data for the statistics, which is correct! The filter should remain that way. Then, I have a filter 'Items' (linked to the item dimension containing the field that filters on the field db_descrizione_articolo). I need to create a table where, when I filter for a single item from the filter I mentioned, 'items', the table should show me all the items sold together with the filtered item. So, when I filter for sold, for an item '001' for example, the table should show all the items that appear with '001' in the sales documents (because I have set the filter on sold, which does it automatically). My problem is the filter on the item because at the moment, if I filter for an item in the table by entering the size 'item' (always containing db_descrizione_articolo), it only gives me the filtered item. I don't need complex solutions, I don't need to intervene through scripts, I need to understand which strategy to use. Very often I find solutions that don’t display any data.
Please note the forum you have posted to is for the Data Integration product Compose, our automated Data Warehouse solution. To reach your target audience, please consider posting your question here: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense
