Display all Sold Together Items with the Filtered Item (from a filter on the items)
Hello, I have a problem to solve regarding Qlik Sense. I have a dashboard where I have a 'Type of Statistics' filter that filters by type of statistics, such as sold, revenues, etc. So, when this filter is set, it selects the documents from which it should take the data for the statistics, which is correct! I set this filter to sold. I have an 'Items' filter (which filters on the item_code field). I need to create a 'table' chart where, when I filter for a single item from the filter I mentioned, 'items', the table should show me all sold items along with the filtered item. For each 'document_id', I know the items present in it. This is the loading of the table for the lines of the sales document.
Hello, the 'p' function seems not to be working, it is important for me to be able to see all the sold items along with the filtered item.
RIGHE_DOCUMENTALI_DI_VENDITA CARICO * IN LINEA [ document_id,item_code,quantità, 000001,A001,20, 000001,A002,30, 000001,A005,15, 000002,A001,5, 000002,A003,6, 000002,A008,23, 000008,A006,13, 000010,A002,19, 000010,A005,18, 000012,A006,8, 000012,A004,16, 000012,A007,4, ];
I load this data from the database, I filter for 'A001', I need to create a dimension on the article code that gives me as a result all the items sold with 'A001'.
