Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kolakiran
New Contributor II

I have a scenario that i have fields called STARTDATE and ENDDATE, i need to calculate only CurrentWeek, Nextweek and Next following Week (eg: current week 37, need to show data only for 37,38,39) excluding Weekends

Hi Experts,

i have a scenario that  i have fields called STARTDATE and ENDDATE,  i need to calculate only CurrentWeek, Nextweek and Next following Week (eg: current week 37, need to show data only for 37,38,39) excluding Weekends

For example:

I have a data for

startdate,enddate, value

13/09/2017,26/09/2017,7

06/09/2017,27/09/2017,5

WEEK is filter:

my calculation should be

Current week= in this week remaining days(3)= 7*3= 21 and 5 *5= 25  total =21+25=46

Nextweek= in this week remaining days(5)= 7*5= 35 and 5 *5=25  Total=35+25 = 60

Nextweek= in this week remaining days(2)= 7*2= 14 and 5 *3=15  Total = 14+15= 29

like this

Thanks

Kk

2 Replies
akpofureenughwu
Contributor II

Re: I have a scenario that i have fields called STARTDATE and ENDDATE, i need to calculate only CurrentWeek, Nextweek and Next following Week (eg: current week 37, need to show data only for 37,38,39) excluding Weekends


Hello Kiran,

Please can you drop a sample QVW file so we can see what's you want to achieve?

Regards

kolakiran
New Contributor II

Re: I have a scenario that  i have fields called STARTDATE and ENDDATE,  i need to calculate only CurrentWeek, Nextweek and Next following Week (eg: current week 37, need to show data only for 37,38,39) excluding Weekends

Hi Akpofure,

please find the attached  excel for your reference

      

StartDateEndDatevalueCurrent week next weeknext folowing week
6-Sep27-Sep210106
9-Sep12-Sep2400