Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Contributor II

Sum revenue for each saturday in a month

Hi all,

In our business environment we book orders which gives us a certain amount of revenue.

We would like to see how this revenue is growing per week, where the reference day is saturday.

I would like to have a table like this:

MonthFirst satSecond satThirds sat
Fourth sat
Fifth sat

The expression is should be something like:

sum(if(Bookdate <= (date of 1/2/3/4/5 saturday in a month) Revenue))

In the sample document I have made an example of what I would like to see, but in my opinion the expression I use is way to complex.

Is it possible to get the ' date of 1/2/3/4/5 saturday in a month'  with a variable or in another way?

Many thanks.



2 Replies
Valued Contributor

Re: Sum revenue for each saturday in a month


Find the attached file. It is very helpfull for you


Re: Sum revenue for each saturday in a month

You'll need to decide and define how to handle the weeks that span between two months.

I assumed you want to aggregate always a full week from Sunday to Saturday.

Then show these aggregates for the Saturday in each month.

Please check attached.

Community Browser