Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

rkpatelqlikview
Contributor 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
Highlighted
Surya
New Contributor III

Re: Last week till last working day sales from the year start

Hi ji,

try this once

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

Community Manager
Community Manager

Re: Last week till last working day sales from the year start

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

Re: Last week till last working day sales from the year start

This is in Qliksense