topic Re: How to calculate previous week value ? in QlikView

How to calculate previous week value ?

dolly777 — Tue, 12 Sep 2017 07:13:55 GMT

Hi All,

How to calculate previous week value?

in data source I have [Week Ending] field where field is in numeric date format and having last day of every week value

I also created one field prevWeekEnding in my data model

I am using following formula

=sum( {$<[Week Ending]= ,prevWeekEnding={"$(=Date([Week Ending]-7))"}>} ListUSD])

while I am using this formula ,

without any selection I am getting result 0 and if I select any date from [week Ending ] , I got the result of current date selection value.

Chanty4u — Tue, 12 Sep 2017 07:21:26 GMT

Hi check,

Anil_Babu_Samineni — Tue, 12 Sep 2017 07:21:42 GMT

I am not following as guessing you must have Week field, then try this?

=sum( {$<[Week Ending]= ,prevWeekEnding={"$(=Date([Week Ending]-7))"}, Week = {'$(Max(Week) - 1)'}>} ListUSD])

shraddha_g — Tue, 12 Sep 2017 07:22:59 GMT

Try

prevWeekEnding={"$(=Date(max([Week Ending])-7))"}>}