Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Weekly QVD Load - Only total last load

I have a weekly QVD load coming through to Qliksense and Im keeping a history of weekly totals.  I need to show totals from the last load  and not totals from all previous loads.  Example: the report has run weekly for three weeks and my measures are showing totals for the three weeks combined and not the last load.  Im assuming I have to add some kind of date formula using the reload date to my existing formulas?? Any help would be appreciated. 

4 Replies
Highlighted
Contributor II
Contributor II

Re: Weekly QVD Load - Only total last load

Please try below link covering the concept of incremental load :-

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

 

Highlighted
Contributor II
Contributor II

Re: Weekly QVD Load - Only total last load

When you are loading the data, add flag Today() as [Loaded Date] in load script and after that use condition where [Loaded Date] = XX/XX/XXXX

Highlighted
Partner
Partner

Re: Weekly QVD Load - Only total last load

Hi,

If I understand correctly you store QVDs and your script stores multiple QVDs in a load?

If you want all the QVDs that have been stored in a certain time period you can also use the formula QvdCreateTime(). Search for your file in the folder structure and evaluate the QVD create time. This way you won't get all the previous loads, but just the last one.

Jordy

Climber

 

Work smarter, not harder
Highlighted
Contributor III
Contributor III

Re: Weekly QVD Load - Only total last load

Thanks for all the replies.  I will certainly store these away.  I found a solution to my issue, quite simple in the end, as each item has a unique identifier, I have just done a distinct count so as not to include the duplicates which may come through each week if not completed in the previous months