Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am facing a small problem that I would like to solve
As the following picture, I have a pivot like that:
The aim of my table is: knowing which customer has bought which product and in which is the first date (my measure), but I am interested also in which product has not bought one customer.
I would like to know if is possible to avoid the fact that when I select one customer for example 'A' the dataset is restricted in automatic to only the product that this customer has bought. My ideal output is that the customer column will be responsive at any customer filter, but the product column not.
I already know that there is the possibility to use 1 in the set analysis or the expression <Customer=>, but by doing that the Customer dimension is not filterable!.
Hoping to be clear,
Regards,
Giulio
What is the expression you are using? Would you be able to provide a sample?
Hi Giulio,
to solve your issue, i suppose, you need an extension
look at this: http://branch.qlik.com/#!/project
i hope that helps
Beck
Hi sunny the expression is just:
Dimension on the column
Dimension on rows
Output expected:
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.
Thanks
May be this
Date(min({<Customer = p(Customer), Product>}Date)) + Avg(TOTAL {1} 0)
Hi ,
Please try below code,
it brings all the customers when a single product is selected plus product is null (when a customer has not bought a product).
Min({<Sheet2.Product,Sheet2.Customer = P({<Sheet2.Product={'$(=Sheet2.Product)'}>} Sheet2.Customer)>} Sheet2.Date)
Hi Anand,
what the command Sheet2 supposed to mean?
I am using Qlik Sense
Hi Giulio,
Please ignore Sheet2, the logic is same in qlilksense.
Thanks.
Attached the QS screenshot.