But I know the above expression ain't right to get the correct value. I'm completely new to Qlik sense and have started learning.
Could you please help me with an expression to get the sum of MTD Sales for last week for the KPI measure
P.S. The Week numbers are linked to Sunday's date, that's why I have used week start function and also the Week numbers in my calendar and Qlik's are different as the only common calendar field is Date. Also on the above expression I tried to wrap the Date as number, because only then it is working due to the formats.
I read your requirements again, but do you need the sum of values for the past 7 days or do you need the sum of values of the previous week? Example: This week is week number 15 (202115) and previous week is (202114) . And I guess you want only show the sum of values of week 14