topic Re: How to track Sales based on customer-specific dates in QlikView

How to track Sales based on customer-specific dates

Fri, 20 Nov 2020 18:02:30 GMT

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!

Re: How to track Sales based on customer-specific dates

Thu, 26 Mar 2015 13:04:33 GMT

Check with this function

which explains the Trace function as follows:

Trace

The trace statement writes string to the Script Execution Progress window and to the script log file, when used.

The syntax is:

trace string

Examples:

trace Main table loaded;

trace $(MyMessage);

See the Examples here

QlikView Addict: QlikView TRACE Statement

Re: How to track Sales based on customer-specific dates

Thu, 26 Mar 2015 15:30:05 GMT

Thank you, but I forgot to mention that I would like be able to do this in the expression with already ready dimensions without the need to change any script. "Customer", "date" and "Sales" already exist so I would like to be able to do this in expression using the existing ones. Do you think it is possible?

Re: How to track Sales based on customer-specific dates

awhitfield — Thu, 26 Mar 2015 15:32:25 GMT

HI LazuPets,

Can you post a sample QVW?

Andy