If there's only one field that you care about how it changes from week to week, you don't need a huge data volume to store it. Let's say your weekly file currently has this data:
KeyField, Field1, Field2, Field3, FieldToMonitorWeekly
I'd break that into two different tables:
KeyField, Field1, Field2, Field3
KeyField, Week, FieldToMonitorWeekly
Not sure I've correctly understood your question, though.
If i have understood your problem, you can try using an extra field for WEEK in the files separately (in both the files) and then try analysis the data taking this WEEK field as flag (in if condition or SET). This would also let you avoid the problem of hugeness of the file.
I think you have understood my problem well. But can you help me with the exact solution?
I understood the part where i have to create an extra field in each of the file.
How exactly can i link both the files in one Qlikview document so that if i select week 1 then week 1 data is displayed and if i select week 2 then week 2 data is displayed.
I am pretty new to this application hence not able to understand SET condition that you are talking about. Can you please help me with step by step solution for the same if possible ?
Thanks in advance
Hi John Thanks for your attempt as well.. There are many data points ( around 20) or so which changes every week so yes i understood that to that extend the volume would be reduced...but file volume would be a challenge say 4 months down the line if not 2 months.
I'm trying to do something with variance too - in particular schedule and budget variance. I have to show this variance according to a project manager - which I think I have figured out how to do. But, I don't know how to do it in terms of day, week, month. I have a field called snapshotdate and that's all I have to work with. Do I have to go into the listbox or table properties and do an sql expression that turns the date into the three different fields I want? please let me knwo if I'm on the right track. I would greatly appreciate it. thank you.