Did you try...
LOAD time as Year,
In front end you can use Year as a filter to pick and choose...
Cross table will create some extra rows
Hi Shahbaz,thanks for your help. I used your code and now it works. But i am wondering what does 3 mean in the crosstable? can we use 2 here?? and also we load the time as year. does it mean we make the time as a global or master calendar? i also have problems in defining time variable. For example, i uploaded two files. One is enrolment over 2013-2018. and the other is financial index over 2013-2017. The data in these two files are not exactly consistent. I tried to use the time in enrolment as filter but it doesn't affect the financial index when i select the time in enrolment. I am wondering how to always set the time as calendar, then all the time variable is connected and can be globally used in Qlik sense? Thanks
3 would mean after 3rd dimension it will club all the dimensions.
If you give 2 then you'll have values from 'W' added to Age field.
For your time/year I see your data is just Year based and it is not date sliced...
Not sure how that would work....
But search for Generate dates from Year field in community...
I once had similar question....
check for answer from Anil in below link