Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need display a rolling 3 months record of student enrollment of each subject. If it is Dec, it will show the number for Sep, Oct, Nov. Jan will show number from previous year Oct, Nov, Jan. No idea how can i achieve this, anyone can help? Thank you.
Sample data:
LOAD * Inline [
Subject, year, month, student number
Biology,2021, 10, 12
Biology,2021, 11, 13
Biology,2021, 12, 14
Biology,2022, 1, 12
Chemistry,2021, 10, 27
Chemistry,2021, 11, 28
Chemistry,2021, 12, 23
Chemistry,2022, 1, 30
];
Output:
Nov Dec Jan
Biology 13 14 12
Chemistry 28 23 30
@mimivan Could you please be clear with your requirements? Do you need rolling 3 months for each column or when you click on any of the month, you need to show the values for the last months.
Say for example today is month Feb. I will need to show all subjects of the last 3 months Nov, Dec, Jan.
Hi,
Please look at this as-of table concept :
https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130
you will able to get desired output using this script.
HTH
Vikas