How to see the Updated values direct discovery concept in Qlikview...??

[vishalgoud]

Hi all ,

new to direct discovery concept.

working on Direct Discovery concept in Qlikview, established live connection from Qlikview  to Database view in SQL DB.

Doubt: How to get the latest updated Value for a particular field. Some times I see the Updated value is Displaying directly in the application and some times I need to reopen the application if I want to see the updated value.

What is the exact way to  see the updated value. do I need to reopen the application, or any other method is there.

please suggest me what exactly works.

Kind Regards,

V.

[Anil_Babu_Samineni]

May be assigned scheduled with every 5 Minutes or some thing. In fact, Direct Query can fetch update data directly once it will start change the values

LET a =if(left(subfield((now()-ReloadTime())*1440,'.',2),1)=5,999,0); // Create Script

Macro

Sub ReloadDoc

   ActiveDocument.Reload

   ActiveDocument.Save

End sub

Then, Use this Macro Name for Variable Trigger onchange from Triggers Tab