Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
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?
Find the attached file. It is very helpfull for you
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.