Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

hencovanee
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
110000200003000040000
215000300004500060000

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.

Regards,

Henco

2 Replies
kumarnatarajan
Valued Contributor

Re: Sum revenue for each saturday in a month

Hi,

Find the attached file. It is very helpfull for you

MVP
MVP

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