Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
You need to use the master calendar. How to do it, look here
Generating Missing Data In QlikView
Regards,
Andrey
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.
Hi Megan,
Daily File only + Master Calendar
Regards,
Antonio
Thank you everyone. I decided to merge into one file!