Default selection on Open

[#1]

I would like like to know if there is a way I can make default selection of my products based on the indicator.I would like to have the products selected with an indicator 'Y' on open.

Please let me know.

[#2]

You can use a macro and setup a trigger when the user is opening the document

Look at the API guide. and in the document settings.

Philippe

[#3]

Thanks For the reply.

I did tried usinga a macro ,But I didn't find a way to evealuate by Indicator='Y'.

[#4 · Accepted solution]

ActiveDocument.Fields("Indicator").Select "Y"

Select everything with Y in the Indicator field and QlikView will only display those records. You don't have to select each Product Name manually, QlikView will handle that through the field associations.

[#5]

Thanks,That works but I would like to see my products with indicator Y selected as green on open.

Thanks again

[mike_garcia]

You can go to Settings > Document Properties and select the tab named 'Triggers'. Then, you canb add, as an Action to perform on open, the desired selection.

Mike.

[fedcas]

Ok, but if I have "Y" and "X"? How is the best way?

Thanks!!

[#8]

Try this:

ActiveDocument.Fields("Indicator").Select "Y"
 ActiveDocument.Fields("Product").SelectPossible

That selects Y in the Indicator field and then selects all associated Products, which makes them green.

[#9]

Hi All,

I have also posted almost same post same like this. Hope some one who gave solution here can help me out too. Waiting for your reply!

http://community.qlik.com/forums/t/24345.aspx

[#10]

Thank you Miller