Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi ji,
try this once
sum({<datenum = {" >= $(=num(yearstart(max(datenum))))"} <= {(=num(weekstart (max(datenum)-1)))}>}sales)
This is in Qliksense