Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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