4 Replies Latest reply: Oct 18, 2018 1:37 PM by Shahbaz Khan Mohammed RSS

    how to group multiple fields into one dimension?

    peter wang

      Hi there.

      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