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: 
Not applicable

Sum function for the last day in week

I want to display sales amount only for the last of any given dimensions of week,month,Quarter,Year.

I just want to show amount end of week, not total for per week.

For example:

1/1 :100

2/1 :150

3/1: 160

4/1: 140

Suppose: 4/1 is the last day in week: so it displays amount = 140

5 Replies
tresesco
MVP
MVP

How does your data look like?

1/1 :100 -> Is 1/1 coming as a one field and :100 as another? Please consider providing a sample data set preferably in tabular format.

Not applicable
Author

1 Jan: amount= 100

2 Jan: amount = 150

3 Jan: amount =160

4 Jan: amount =140

Suppose 4 Jan is the last day in that week: so it displays amount=140. Please help me

tresesco
MVP
MVP

If your date field is a proper date field, you can use FirstSortedValue().

Not applicable
Author

CAN U WRITE full function for this? i am very new with Qlik sense

tresesco
MVP
MVP

You have given two different samples of data set. I am afraid that this is not how your actual data look like. Suggest to upload a qvw/qvf file with sample (preferably inline) data.