Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSensor
Partner - Creator
Partner - Creator

Refer to data in another file

Hi, 

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.

Any hints how to do that?

1 Reply
Lisa_P
Employee
Employee

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.