Discussion Board for collaboration related to QlikView App Development.
If today is Wednesday for example, and I want to get the full last week's revenue, I use this which works:
However, for some products, there is no data for this week. Then the above set analysis returns the revenue from 2 weeks ago (as opposed to 1 week ago), which is wrong. How do I ensure it returns one week ago no matter what?
Iam nit sure if set analysis is possible in where condition, but I would try
this should take the previous year regardless of any products
View solution in original post
I can't believe that QV gives you the revenue for some products 2 or more weeks ago.
In variable vYEARWEEK the result for today ist 201513
and this value is set in your setanalysis as yearweek definition