Hi all, I have a requirement here which need me to create a YTD and MAT as KPI. YTD is counted from the beginning of the current year (Jan) until current month, and MAT is counted from current month to the last year of current month (for example now is May, so it will be counted from May 2019 to May 2018, total 12 months). This KPI will affect the result of total sales displayed. Anyone has an idea how to achieve this? And also, do I need to connect this KPI to the Sales dimension? Please help! Thank you in advance
Hi Vegar, thanks so much for replying and giving me the solution, however, what I'd like to achieve is like the attached picture, so the YTD and MAT should be act as KPI, so when the user choose YTD, the Total Sales Amount and Volume will change accordingly. Can we achieve this in qlik sense?
