topic Default selection on Open in QlikView

Default selection on Open

Mon, 11 Jan 2010 17:42:15 GMT

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.

Default selection on Open

Mon, 11 Jan 2010 17:51:45 GMT

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

Default selection on Open

Mon, 11 Jan 2010 17:56:41 GMT

Thanks For the reply.

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

Default selection on Open

Mon, 11 Jan 2010 18:03:21 GMT

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.

Default selection on Open

Mon, 11 Jan 2010 18:12:26 GMT

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

Thanks again

Default selection on Open

mike_garcia — Mon, 11 Jan 2010 18:36:07 GMT

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.

Default selection on Open

fedcas — Mon, 11 Jan 2010 21:46:18 GMT

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

Thanks!!

Default selection on Open

Mon, 11 Jan 2010 22:26:50 GMT

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.

Default selection on Open

Tue, 12 Jan 2010 07:14:26 GMT

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

Default selection on Open

Tue, 12 Jan 2010 18:15:12 GMT

Thank you Miller

Default selection on Open

Fri, 15 Jan 2010 07:12:23 GMT

Hi Priyadarshini!

If you have got the solution can you please give some solution for my post also please!

Default selection on Open

Fri, 22 Jan 2010 08:51:48 GMT

Hi All,

Could some one reply for my post here. I want to work on this requirement very urgently.

Regards,

Rikab

Default selection on Open

Wed, 27 Jan 2010 08:12:34 GMT

Hi All,

I waited for long time for your reply but didn't got any reply. Finally got it done by using the following function in the macro. Posted it here so that it will be useful for someone who were looking for the same like me.

Sub selectLatestDate
 ActiveDocument.GetField("Date").Select ActiveDocument.Evaluate("max(ALL Date)")
End Sub

Default selection on Open

Fri, 29 Jan 2010 23:09:56 GMT

Sorry I didn't get a chance to look at forums.Good you got the answer.