I have two files of data: the first file contains data with single events matching to a certain date. The second file contains data with a monthly information. Both files are connected via a certain number.
Now I want to create a pivot table which is based on a quarterly basis. I need to average data from the second file (the monthly based) which works easily by using the QuarterYear option of the date field. Nevertheless, both files are only connected via this unique number and not via a date. I want to include in this pivot table data from the first file (also on quarterly basis) which means data from the first file have to been summed up for each quarter. I didn't manage this task yet but instead (using the sum formula) QlikSense sums up the entire database of the first file and not only the quarter.
The best way is to create a link table to join the two that contains the common fields such as quarter and year and the common number. It is a bit of a complicated process, if you share a sample of your data, I could explain it.
