Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

recurring pattern and deviation from it

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?

1 Solution

Accepted Solutions
Henric_Cronström

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

View solution in original post

3 Replies
Henric_Cronström

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

View solution in original post

Not applicable
Author

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. 

Not applicable
Author

Tested it and it worked great