Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a solution where we use EDX for manually update.
This works allmost as planned.
My problem is that I have 3 varaiables that needs to be updated on each load.
vBatchStartTime, vBatchStopTime, vTag
This is then put into yet another variable:
LET vSQL = 'EXEC master.dbo.xp_AnalogWideHistory ' & vBatchStartTime & ', ' & vBatchStopTime & ', ' & 100000 & ', ' & vTag;
When I hit the button I can see, in some textboxes, that the different variables changes.
The result is shown in a trend line.
The problem is that this does not happend att all.
If I add the code below it works.(I can also remove the edx totaly, but then the button will not work from client)
ActiveDocument.Reload (Not sure why I need it twice, but I do)
How can I get EDX to parse variables as well.
I found one example, but it seems to only handle one variable, and a predefined variable
Anybody got any comments or ideas on how to solve this?