topic Load only the last day's data in QlikView

Load only the last day's data

linoyel — Thu, 08 May 2014 07:29:30 GMT

Hi!

I have a very heavy qvd document that runs once an hour for about 20 mins, which brings data for several years.

Some of the loads in the document are incremental, and some are full.

My task is to create the same document but it will have to show only the last 24 hours and be reloaded every 10 mins.

What's the way to do this?

Plus what's the way to do this without interrupting the every-hour process (cause the exact same tables will be used in 2 documents)?

Re: Load only the last day's data

tresB — Thu, 08 May 2014 07:37:54 GMT

If you have a timstamp field in source file, you can try like:

Let vTime=Now()-Time#(24,'hh');

Load

From <> Where <TimestampFiled> >= '$(vTime)' ;

Note, you have to careful of format of timestamp.

Re: Load only the last day's data

its_anandrjs — Thu, 08 May 2014 07:54:13 GMT

You can try also but add a timestamp field in the database

Let vTime24 = Timestamp(Now()-1);

Load

From Location

Where YourTimestampField >= Timestamp(Now()-1);

Load

From Location

Where YourTimestampField >= $(vTime24);

and schedule the application 24 back and when you can reload the application it gives 24 back data from Now()

Re: Load only the last day's data

linoyel — Thu, 08 May 2014 09:46:35 GMT

OK, thank you for your responses!

One more thing:

Lets say I have a new qvd document that contains 1 tab and it reloads every 20 mins.

Is it possible to add it to another qvd document that reloads every 1 hour?

Meaning that when the user will open the main document, he'll see one tab updated every 20 mins and all other tabs updated every 1 hour?

Re: Load only the last day's data

tresB — Thu, 08 May 2014 09:52:02 GMT

Use the concept of Binay load.

Application1 ->20mins reload

Application2 ->1Hr reload

Application2 should be incorporated in Application1 using binary load.

Re: Load only the last day's data

linoyel — Thu, 08 May 2014 10:27:36 GMT

Thank you!!!

Last question :

When I reload the documents in QMC - they appear in QV desktop --> Open in Server.

But the small document with 1 tab that reloads every 20 mins is only a help document which I'll binary upload into the main one, as you've suggested.

Is there a way to hide the help document from users?

(I know that if I schedule the small doc in Task Scheduler it would solve the issue, but I prefer to have all my docs in the same place and reload them in QMC)

Re: Load only the last day's data

tresB — Thu, 08 May 2014 10:45:02 GMT

... feel like crying ! you did not mark mine as correct !

Well, coming to your next question. Yes, you just have to restrict the UI part; don't design it for that.

Re: Load only the last day's data

its_anandrjs — Thu, 08 May 2014 10:48:53 GMT

Thanks if you got correct answer from the thread so mark the appropriate answer as Correct or Helpful for members and close the thread. If you have another question then post a thread.

Thanks & Regards

Re: Load only the last day's data

linoyel — Thu, 08 May 2014 10:50:39 GMT

Hahaha sorry

Just didn't know which one of your answers to mark as correct cause there are quite a few

Where should I restrict the UI part?...

Re: Load only the last day's data

tresB — Thu, 08 May 2014 10:59:02 GMT

If you use binary load, only the model comes to the new application, not the UI part. And users are not aware of the model. So, design your UI in the new application(may be Help one for your case) to keep the ones from another application.

Re: Load only the last day's data

linoyel — Thu, 08 May 2014 11:36:28 GMT

So, as I understand, I should binary upload the main document into the small one, so the data I need from the small doc will be updated every 20 mins?

Re: Load only the last day's data

tresB — Thu, 08 May 2014 11:40:21 GMT

Even I meant so.

Re: Load only the last day's data

linoyel — Thu, 08 May 2014 11:50:54 GMT

Cool

Re: Load only the last day's data

linoyel — Thu, 08 May 2014 12:48:56 GMT

It gets stuck after the reload...

Maybe it's because the small document is actually the exact copy (just with less data) of the main one?

All field names are the same.. maybe that's what is causing the problem?

In binary load should I make 2 completely different data sets?