Week calculation Qlik sense

[UserID2626]

Hi,

i have to show revenue in straight table day wise based on selection date/month/week/year chart should display result.

having data from 06-june-2018 to current date

When selecting week 52 in filter pane, i have to get result from 30-dec-2018 to 05-jan-2019 , but result shows only for 30-dec-2018 & 31-dec-2018. 

Any solution with simple set expression to get result from 30-dec-2018 to 05-jan-2019 .

if selecting week 1 from year 2019 also should display result from 30-dec-2018 to 05-jan-2019 and selecting date/year/month wants to change accordingly.

thanks !!! 

[sreeramhbk · Accepted solution]

Kindly refer this: 

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Numbe...