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

vishalgoud — Wed, 25 Nov 2020 16:16:04 GMT

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,

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

Anil_Babu_Samineni — Fri, 03 Mar 2017 06:11:23 GMT

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

topic Re: How to see the Updated values direct discovery concept in Qlikview...?? in QlikView

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

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