topic Re: calling subroutine in UI in QlikView

calling subroutine in UI

Anonymous — Sat, 16 Nov 2024 21:47:35 GMT

I Want to call subroutine on click of a button on UI,

Eg IF i click on East East Sub should run, if i click on Central then Central Sub should run like wise..

i don't want to comment uncomment each time in script.

i have attached just sample data in actual its complex script with diff headers conditions.

Re: calling subroutine in UI

Gysbert_Wassenaar — Sat, 01 Dec 2018 08:47:02 GMT

See this discussion: https://community.qlik.com/t5/QlikView-Creating-Analytics/Transfer-selection-to-variable/m-p/450708

Or this one: https://community.qlik.com/t5/New-to-QlikView/Reload-Data-based-on-a-selected-value/m-p/391388#287233

Re: calling subroutine in UI

Anonymous — Sat, 01 Dec 2018 09:28:20 GMT

Hey Gysbert Thanks for replay.

both the post good when we are loading same file or multiple files with same filtering.

good learning for me though this will not solve my problem.

my requirement is

there 22-25 files i have to load each file has different headers & diff process of sanitizing the data

means some may have required columns some may not have for some files will have to filter out some data some wont.. and all the files wont be available each time... like wise & so on...

currently i have created 22-25 QVWs to process each file. to get rid of opening of each file & running code

i want something centralize so that on a click of button or something which will run file no 1 or file no 10 or file no 25.....

Re: calling subroutine in UI

marcus_sommer — Mon, 03 Dec 2018 14:51:56 GMT

The "normal" way would be to use the Qlik server and to create appropriate tasks which runs all your qvw's in scheduled task-chains.

But you could use something like this to update all the qvw's you like:

sub AutomaticReload

dim doc,obj, iRow, app, path, newApp, newdoc
set doc = ActiveDocument
set obj = doc.GetSheetObject("TB01")

for iRow = 1 to obj.GetRowCount - 1
   set app = obj.GetCell(iRow, 0)
   set path = obj.GetCell(iRow, 1)

   set newApp = ActiveDocument.GetApplication
   set newdoc = newApp.OpenDoc (path.Text & app.Text,"","")

   newdoc.Reload
   newdoc.Save
   newdoc.closedoc
next

set obj = nothing
set app = nothing
set path = nothing
set newApp = nothing
set newdoc = nothing

end sub

The routine just runs through a tablebox and reads from there the paths and filenames (you need to load them in any way maybe within an inline-load or an Excel or creates the list with a filelist() loop - with the needed order as far as there are any dependencies between them) and which open/reload/save/close one application after another.

It's quite simple but if you need several task-chains with dependencies and/or any kind of error-handling or some other advanced measures it could become quite difficult and a server-solution (with a publisher) might be far more suitable.

- Marcus