Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
If your date field is a proper date field, you can use FirstSortedValue().
CAN U WRITE full function for this? i am very new with Qlik sense
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.