Default Selections: Macro

[#1]

Hi all,

Can anyone share a sample application having a macro for default selection.

I want to apply this macro post relaod.

All my objects are in a particular state . Would that affect the macro?

Thanks

Khushboo

[#2]

Thanks a ton for your help.

Can u also tell me if i have more than one value for a particular list box....how to select that?

[marcus_sommer]

I have to correct me, state is in general as second parameter for fields available - I had have looked only by the select-statement.

- Marcus

[pamaxeed]

Just change the syntax like that:Select

ActiveDocument.Fields("Dummy", "State 1").Select ("(1|2)")

whre u have to use the '|' as delimiter....

Hope it helps,

Patric

[#5]

i used this but,

ActiveDocument.Fields("PROD_DESC_TXT","Explore_HT").Select"(Poduct-A|Product-B)"

but only PNEUMOVAX is getting slected and prevnar is not getting selected

Thanks

Khushboo

[#6]

Hi,

You can see the problem which i am facing in the dummy application attached.

Thanks

Khushboo

[pamaxeed]

ActiveDocument.Fields("Dummy", "State 1").Select ("(PREVNAR_FRANCHISE|PNEUMOVAX)")

[pamaxeed]

sub Default

ActiveDocument.Fields("Dummy","State 1").Select ("(PREVNAR_FRANCHISE|PNEUMOVAX)")

ActiveDocument.Fields("Dummy1","State 2").Select ("(Pneumovax|Flu_vaccine|Prevnar*)")

end sub

[#9]

Hi Patric,

I am again stuck with this .

On my application i am using dynamic curent selection box one like https://community.qlik.com/docs/DOC-7118.

Now when i use this macro---on straight table current selections i get only PREVNAR_FRANCHISE .

Do you have any idea on this. I have created a discussion on https://community.qlik.com/message/882634?et=watches.email.thread#882634

Thanks

Khushboo