Sum function for the last day in week

[#1]

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

[tresB]

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.

[#3]

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

[tresB]

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

[#5]

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

[tresB]

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.