creation of dynamic dashboard

[deepakqlikview_123]

Hi all,

As per requirement I need to create dynamic dashboard.

I have done with following part.

1.I hav used OLEDB connection to fetch tables from database

2 use all of those tables as it is for schmema geneation in QV .

3 I have scheduled that QVW file in QMC for after enery 5 min.

My question is as per below,

1 For reflecing current records i database at dashboard level do we need to use time function like now().If so how to use that and what is requirement for using same.

2If anyone of u have samele application please attach so that hat will be helpful for me.

thanks,

Deepak

[deepakqlikview_123]

Experts please respond.

Thanks

[ashfaq_haseeb]

Hi,

Deepak can you explain a bit more?

do you want to load data at every second or every 5 min as per your schedule.

and want to refresh data without client action in dashboard?

Regards

ASHFAQ

[deepakqlikview_123]

Hi Ashfaq,

I want to reload data after every 5 min and want to refresh data without client action in dashboard

thanks

[avinashelite]

Hi Deepak,

As per my understanding u want the new records from the DB between last reload and current reload??

if so, you can use the Date as the field to identify those records.

Implement in this way:

*create a QVD for the current table.

*if you have Date field or last modified field then follow the script below

load *

from

Table name where DateFeild>=lastreload and DateFeild<=now().

this will give the  current records

[ashfaq_haseeb]

Hmm,

For this you need to modify few parameters.

Have a look at attached document.

And from your QlikView document, make sure that the highlighted is selected, have a look at attached image.

Regards

ASHFAQ

[deepakqlikview_123]

Can you please provide me sample QVW file for this.So that it will be more clear.

Thanks

[ashfaq_haseeb · Accepted solution]

Hi,

use this and check its updated at every interval you selected.

Regards

ASHFAQ

[deepakqlikview_123]

Thanks Ashfaq

[ashfaq_haseeb]

My pleasure

Regards

ASHFAQ