Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Tracking Sales with customer-specific condition

Hi,

I would like to be able to track the sales of those customers who have purchased one specific product "X" with one extra condition:. only all those customer-specific sales that exist during the same day as the purchase of the product "X" should be taken into account.

The expression below illustrates what I would like to track. I know that Customer&Date combination does not work like it is used below, but if did, the expression below would give me what I am looking for. In other words, I am looking the overall sales of Customer&Date combinations that have purchased this product X. 

Sum({<Customer&Date=P({1<Product={'X'}>})>}Sales)

Could someone be able to help me? Thank you already in advance!

0 Replies