topic Re: GetFieldSelections in Module? in QlikView

GetFieldSelections in Module?

Fri, 13 Jul 2012 11:52:01 GMT

Hiya Guys,

Is it possible to use the function GetFieldSelections within a module?

I have tried this as a test, but it does not work (the Module window opens when triggered, but showing no error):

'*** Update Chart Forecasts depending on current Selection ***'
Sub UpdateForecasts()

Set varSelectionMonth = GetFieldSelections(DateCourse_MonthNumber,",",12)

MsgBox varSelectionMonth

End Sub

Does anyone have any ideas?!

Cheers,

Steve.

Re: GetFieldSelections in Module?

Fri, 13 Jul 2012 12:05:53 GMT

try to make a textbox (paste a getselected funciont to it) and then go to module take the value from textbox

Re: GetFieldSelections in Module?

erichshiino — Fri, 13 Jul 2012 12:53:53 GMT

Hi,

At the module, the method .evaluate is very useful.

You can use any expression that you would use at the interface as an argument.

In your case, you can try:

Set varSelectionMonth =ActiveDocument.Evaluate( "GetFieldSelections(DateCourse_MonthNumber,",",12)" )

MsgBox varSelectionMonth

Msgbox (ActiveDocument.Evaluate("GetFieldSelections(DateCourse_MonthNumber,",",12)" )

Hope it helps,

Erich

Re: GetFieldSelections in Module?

Fri, 13 Jul 2012 12:58:57 GMT

this one works fine

Msgbox (ActiveDocument.Evaluate("GetFieldSelections(X)" ))

Re: GetFieldSelections in Module?

Fri, 13 Jul 2012 13:30:11 GMT

Thanks Guys!

The ".Evaluate" function is exactly what I was after!

Strangely enough, it was the "Set" keyword which was causing the Module window to open when calling the subroutine. Without it, this code worked fine:

varSelectionMonth = ActiveDocument.Evaluate("GetFieldSelections(DateCourse_MonthNumber,',',12)")

MsgBox (varSelectionMonth)

I'm not entirely sure when/why to use "Set" - QlikView has so many different (illogical!) ways to do things it's appalling!!!

Cheers,

Steve.