Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Returning data of Friday on Monday

Hi Guys,

every morning I want to show my colleagues the sales of yesterday.

We're not open in the weekend, so on Monday I want to show the sales of the previous Friday.

Should I script this in my calendar? And if yes, what is the best way to do this?

Attached you'll find the script of my calendar.

Thanks in advance!

Cheers,

Mike

1 Solution

Accepted Solutions
Highlighted
Champion II
Champion II

You should be modifying the expression like below

example

=if(num(WeekDay(Today()))= 0   /// Checking if today is Monday

, sum({<SalesDate = {"$(=DATE(Today()-3,'YOURDATEFORMAT'))"} >}Sales)   // Sales for Previous Friday

,else_your_existing_expression )

View solution in original post

5 Replies
Highlighted
Champion II
Champion II

You should be modifying the expression like below

example

=if(num(WeekDay(Today()))= 0   /// Checking if today is Monday

, sum({<SalesDate = {"$(=DATE(Today()-3,'YOURDATEFORMAT'))"} >}Sales)   // Sales for Previous Friday

,else_your_existing_expression )

View solution in original post

Highlighted
Partner
Partner

First load your data in App.

Sales:

LOAD * FROM SalesData.qvd;

//Then calculate maximum date of your data.

MaxDate:

LOAD max(Date) as MaximumDate

Resident Sales;


LET varMaxDate = num(peek('MaximumDate',0,'MaxDate'));

This should solv your problem.

Highlighted
Creator II
Creator II

That worked perfectly in the expression of my chart, awesome!

Thanks a lot Vineeth

Highlighted
Creator II
Creator II

I persume I'll have to do this in my calendar script in my loading script Shubham?:)

Highlighted
Partner
Partner

Yes