Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dan-ketil
Contributor II

Using EDX with variables

Hi

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

Examle:

'11-11-2011 10:00:00',

''11-11-2011 11:00:00',

'3201L50H007.PV','3201L50H008.PV'

This is then put into yet another variable:

LET vSQL = 'EXEC master.dbo.xp_AnalogWideHistory ' & vBatchStartTime & ', ' & vBatchStopTime & ', ' & 100000 & ', ' & vTag;

SQL $(vSQL);

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

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

http://community.qlik.com/message/160822#160822

Anybody got any comments or ideas on how to solve this?

Dan

Community Browser