topic Re: recurring pattern and deviation from it in QlikView

recurring pattern and deviation from it

Wed, 12 Feb 2014 08:37:17 GMT

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?

Re: recurring pattern and deviation from it

hic — Wed, 12 Feb 2014 08:59:32 GMT

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

Re: recurring pattern and deviation from it

Thu, 13 Feb 2014 01:17:02 GMT

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.

Re: recurring pattern and deviation from it

Thu, 13 Feb 2014 05:35:19 GMT

Tested it and it worked great