Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rkpatelqlikview
Creator III
Creator III

Last week till last working day sales from the year start

Hi Qlik,

I have a question. suppose i want to show the sales from the 1st January 2019 to till 14th March 2019(Weekend).

  Like below example.

Capture1.PNG

15th and 16th march no holidays.So no need to show that results.

After completion of this week it should change to  As of 21st March2019. 22nd and 23rd Holiday again business week will start from sunday 24th Mar-2019.

Thanks in Advance.

 

3 Replies
Surya
Creator II
Creator II

Hi ji,

try this once

sum({<datenum = {" >= $(=num(yearstart(max(datenum))))"} <= {(=num(weekstart (max(datenum)-1)))}>}sales)

Sue_Macaluso
Community Manager
Community Manager

Is this for QlikView or Sense? Id like to move this to the correct product forum. Thanks
Sue Macaluso
rkpatelqlikview
Creator III
Creator III
Author

This is in Qliksense