This content has been marked as final. Show 7 replies
Hi sunny the expression is just:
Dimension on the column
- Product (source: fact table and all product table)
Dimension on rows
- Customer (source: fact table and all customer table)
- One pivot table that shows for each product the min (date) for a customer, but I would like to be able to filter on one product and see every customer for this product with the null value for those customers that have not bought the product. What happens is that (due to the fact that there is no link between a Product and a Customer that has not bought it) when I select a product Qlik gives me in automatic just the min(Date) for every Customer that has bought it and ignore in automatic the others. Exists one workaround to avoid this?
I am in a meeting right now so tell me if you need a sample data for this, or if I was not clear enough.