I would like to ask that how to group multiple fields into one dimension in qlik sense? for example, i would like to group age from 0 to 19 into one dimension instead of different columns. i tried using crosstable, but i have three dimensions so i failed.
can anyone help me? here is the excel file.
another question is ,how to link different sheet in qlik sense? i tried to solve the above question in this way:
first i deleted the time and created the file for each year. i used crosstable to group the multiple fields.but after this, how can i connect data in different year? i mean 'connect' is to make the year as one dimension so that i can use as filter. thanks
Re: how to group multiple fields into one dimension?
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