Discussion board where members can learn more about Qlik Sense App Development and Usage.
As an example I have a sales table and a typical master calendar table with SalesDate, Month, MonthYear, etc.
I need to make a table/graph with each successive variation from month to previous month, each month shows the increase % in sales from previous month, like this:
Variation previous month
My doubt is how to get the sales from the previous row on dimension MonthYear, for all the dimension values.
Go to Solution.
LOAD *,MonthName(SalesDate) as MonthName; LOAD Date#(SalesDate,'YYYY-MM-DD') as SalesDate, Sale FROM "https://community.qlik.com/message/1276468" (html, codepage is 1252, embedded labels, table is @1);
Dimension : MonthName
You can do it with an AsOf table: The As-Of Table.
Thanks Antonio, it worked!