topic Re: week caluclation in QlikView

week caluclation

Sat, 13 Dec 2014 14:22:55 GMT

Hi,

I need to sum up the before 4weeks sales in straight table When I select week in week listbox

Please help

ecolomer — Sat, 13 Dec 2014 15:34:32 GMT

Here you have an example similar but with month

For weeks is the same

maxgro — Sat, 13 Dec 2014 22:41:38 GMT

Sum({$ <week={">=$(=rangemax(0,max(week)-4))"}>}sales)

Gabriel — Sun, 14 Dec 2014 02:38:42 GMT

Hi Reddy,

Personal what I would do is to create Point In Time flags in calendar and use WeekToDate flag, where WeekToDate = 1 in your Set Analysis.

Your Set Analysis expression will just be Sum({<%PiT_WeekToDate = {1} >}Amount)

Hope this is helpful