topic Re: Data- What is the best option? in QlikView

Data- What is the best option?

megan_deboer — Mon, 07 Aug 2017 14:47:33 GMT

Good Morning,

I'm working with Qlik Sense Desktop and trying to take three files and create apps/sheets off of them. Each file consists of the same data points but, one file is monthly data (01/2016-04/2017), the second file is weekly (05/2017-07/2017), third is daily data. Again, each file consists of the same data points just different cadences of time. In order to make a filter for example off of year, I would need to make one filter off of each file and I don't know of a way to do that.

My question is it more advantageous to merge all three files with different date ranges or is it possible to combine the files within the different dimensions and measures? I'm open to any suggestions.

Thank you!

Megan

Re: Data- What is the best option?

ahaahaaha — Mon, 07 Aug 2017 14:51:37 GMT

Hi,

You need to use the master calendar. How to do it, look here

Generating Missing Data In QlikView

Regards,

Andrey

Re: Data- What is the best option?

dan_sullivan — Mon, 07 Aug 2017 14:51:40 GMT

assuming your daily file contains all the data, i would only load and use that one. You can then create calendar flags during the load to quickly be able to calculate month, year, week values using set analysis.

Re: Data- What is the best option?

antoniotiman — Mon, 07 Aug 2017 14:55:26 GMT

Hi Megan,

Daily File only + Master Calendar

Regards,

Antonio

Re: Data- What is the best option?

megan_deboer — Wed, 09 Aug 2017 18:51:07 GMT

Thank you everyone. I decided to merge into one file!