Reload Data based upon sheet selection criteria?

Mon, 23 Sep 2013 13:06:28 GMT

My company has Low T computers, (windows XP) and large datasets, so is there any way to reload data based upon a user selection in a sheet or a run time variable in the data loading script? that would solve a small demo issue for some users. . .

thanks in advance. .

Re: Reload Data based upon sheet selection criteria?

Mon, 23 Sep 2013 14:27:30 GMT

You can add a trigger to the field. Go Settings -> Document Properties -> Trigger

Have the trigger execute a macro "eval".

Sub Reload

ActiveDocument.reload

End Sub

sub eval

set x = ActiveDocument.Fields("YourField").GetSelectedValues

if x(0).Text = "YourSelection" then

Reload

end if

end sub

Try this. If it doesn't work, look into EDX.

topic Re: Reload Data based upon sheet selection criteria? in QlikView

Reload Data based upon sheet selection criteria?

Re: Reload Data based upon sheet selection criteria?