Date Issue in Qlikview

[Anonymous]

Hi Team,

I have come across a requirement in which the the product X has a lag of 2 days.

So when i filter the report for Week = 9/9/2017, then the Product X must show values for the week 9/11/2017.

Filter applied	Week:9/9/2017
Expected Output
X Week	Week	QTY
9/11/2017	9/9/2017	100
9/11/2017	9/9/2017	200
9/11/2017	9/9/2017	300
original Output
X Week	Week	QTY
9/9/2017	9/9/2017	80
9/9/2017	9/9/2017	90
9/9/2017	9/9/2017	110

Any help with this would be appreciated.

Thanks,

Harshala

[sunny_talwar]

Try this

=Sum({1<date={"$(=date(num(date)+1))"}>}Value)

or this

=Below(TOTAL Sum({1<date={"$(=date(num(date)+1))"}>}Value))

[Anonymous · Accepted solution]

Hi Sunny, i tried the below expressions earlier it doesn't work.

Sum({1<date={"$(=date(num(date)+1))"}>}Value)

also the other expression :

=Below(TOTAL Sum({1<date={"$(=date(num(date)+1))"}>}Value)) - doesn't work if i remove the date field.

Solution: i need ignore the date selection

Sum({< weekdate = {"$(=date(Num(Weekdate)+2,'MM/DD/YYY'))"} ,date= >}QTY)