topic Re: Default Selections: Macro in QlikView

Default Selections: Macro

Thu, 01 Oct 2015 07:59:16 GMT

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

Re: Default Selections: Macro

pamaxeed — Thu, 01 Oct 2015 08:05:39 GMT

Hi,

what you mean with all my objects are in a particular state. Would that affect the macro?

Regards,

Patric

Re: Default Selections: Macro

Thu, 01 Oct 2015 08:12:31 GMT

I am very much new to macro.

I mean say in a list box-product .i want to select default value as Product-A.

This list box is in a state -A?

can anyone help me with this macro.

Khushboo

Re: Default Selections: Macro

pamaxeed — Thu, 01 Oct 2015 08:25:49 GMT

So you are using alternate states in your app?

You can try to to do something like that:

ActiveDocument.Fields("YourField", "State1").SelectValues("yourValueHere")

Cheers,

Patric

Re: Default Selections: Macro

Thu, 01 Oct 2015 08:36:08 GMT

so if i write this macro :

sub Default

ActiveDocument.Fields(".PGRP_LVL_1_DESC_TXT", "state-A").SelectValues("Product-A")

end sub

and on post reload ....apply this macro Default.

It should work ?

Thanks

Khushboo

Re: Default Selections: Macro

Thu, 01 Oct 2015 08:39:01 GMT

after reload i am redirected to that macro

Re: Default Selections: Macro

marcus_sommer — Thu, 01 Oct 2015 08:43:52 GMT

Does this macro work if you execute it from the modul-editor per click on Test-Button? What is the reason for these selection then normally a reload changed no former selection?

- Marcus

Re: Default Selections: Macro

Thu, 01 Oct 2015 08:47:06 GMT

when i test this macro.it gives type mismatch error?

Re: Default Selections: Macro

pamaxeed — Thu, 01 Oct 2015 08:52:42 GMT

Check it out.

It works....

I corrected the syntax, now it is working fine.

Regards,

Patric

Re: Default Selections: Macro

marcus_sommer — Thu, 01 Oct 2015 08:54:55 GMT

If I have a closer look on your statement I notice the attempt to select this field within a certain state but the APIGuide didn't know such a parameter and I think it made no sense, too then a field is global and only sheets respectively sheet-objects could belong to a state. Further the syntax isn't quite correct then it must be:

ActiveDocument.Fields("MARKETSIZINGV1.PGRP_LVL_1_DESC_TXT", "Explore_OAMS").SelectValues("Prevnar Franchise")

- Marcus

Re: Default Selections: Macro

Thu, 01 Oct 2015 08:57:58 GMT

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?

Re: Default Selections: Macro

marcus_sommer — Thu, 01 Oct 2015 09:03:46 GMT

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

Re: Default Selections: Macro

pamaxeed — Thu, 01 Oct 2015 09:04:12 GMT

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

Re: Default Selections: Macro

Thu, 01 Oct 2015 09:37:00 GMT

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

Re: Default Selections: Macro

Thu, 01 Oct 2015 09:52:09 GMT

Hi,

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

Thanks

Khushboo

Re: Default Selections: Macro

pamaxeed — Thu, 01 Oct 2015 09:52:11 GMT

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

Re: Default Selections: Macro

pamaxeed — Thu, 01 Oct 2015 09:56:47 GMT

sub Default

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

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

end sub

Re: Default Selections: Macro

Mon, 05 Oct 2015 13:45:07 GMT

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