topic why error occur when clear all ? in QlikView

why error occur when clear all ?

Mon, 11 May 2009 15:06:29 GMT

Dear all,

It has "EN,CN,TW" for displaying multiple language , when I select one language , it's ok. And I want to display EN (AS default) language when I click Home-->Clear but It jump to edit macro module , I know the macro has bug but i don't know how to modify it (Qlikview is 9.0 beta version ), can someone help me ?

thanks in advance

why error occur when clear all ?

Mon, 11 May 2009 16:42:25 GMT

my vbs macro:

sub LangSetting
set f = ActiveDocument.Fields("langName").GetSelectedValues
if f.item(0).text = "CN" then
call ChangeCn
elseif f.item(0).text = "TW" then
call ChangeTw
else
call ChangeEn
end if
end sub

sub ChangeEn
ActiveDocument.Variables("lang").SetContent "EN",true
end sub

sub ChangeCn
ActiveDocument.Variables("lang").SetContent "CN",true
end sub

sub ChangeTw
ActiveDocument.Variables("lang").SetContent "TW",true
end sub

how can i modify it ?

why error occur when clear all ?

Mon, 11 May 2009 16:48:33 GMT

To avoid any problem, you can set this field language so that always one value is selected ( field properties).

Rgds,

Sébastien

why error occur when clear all ?

Tue, 12 May 2009 08:09:50 GMT

thanks, it is a good idea !

why error occur when clear all ?

Wed, 13 May 2009 14:35:04 GMT

Thank spastor, it work now !

why error occur when clear all ?

thanomjit — Wed, 13 May 2009 15:37:18 GMT

sub LangSetting

..... error resume next '<--You can command line ----

set

f = ActiveDocument.Fields("langName").GetSelectedValues

sub

why error occur when clear all ?

Wed, 05 Aug 2009 16:35:38 GMT

Hi.

I had the same problem, but merely by adding "()" it worked to clear all without a default value.

From this :

selectedValue = ActiveDocument.fields("JF_Name").GetSelectedValues.Item(0).text

To this:

selectedValue = ActiveDocument.fields("JF_Name").GetSelectedValues().Item(0).text