recurring pattern and deviation from it

[#1]

I am new to Qlikview and went through the basic tutorials and was able to create the basic saladas document.  I would like to ask what aggregations can be used to answer specific questions with regards to recurring behavior and deviations from it.  Example of these types of questions would be:

"When does customer x usually order in the month?"

"What day of the week does this customer usually order?"

Then show on the dashboard customers whose latest orders deviate from the pattern.

Is there an example of this kind of project I can download or follow?

[hic · Accepted solution]

The aggregation function that returns the most commonly occurring value is Mode(). So, if you use

     Mode(Day(Date))

     Mode(WeekDay(Date))

you will get what you want. (Better if you define Day(Date) and WeekDay(Date) already in the script, though.)

HIC

[#3]

Thank you,

I will try this out today.  I would assume that not equal to the mode value would be the deviations to look out for. 

[#4]

Tested it and it worked great