topic Re: On open document dynamic default selections in QlikView

On open document dynamic default selections

mayankraoka — Fri, 05 May 2017 19:29:10 GMT

Hi Team,

I want to open the document on access point with max month of data get selected by default on opening document first time.

I dont want to do this from On open document triggers.That is breaking my other functionality.Is there any other way to make default selection max of month dynamic on open without triggers?Any workaround is helpful.

Regards,

Mayank

Re: On open document dynamic default selections

neelamsaroha157 — Fri, 05 May 2017 19:38:50 GMT

You can do it with OnPostReload.

Re: On open document dynamic default selections

mayankraoka — Fri, 05 May 2017 19:47:16 GMT

Hi Neelam,

How it can be done can you explain this.Is this without triggers?

Regards,

Mayank

Re: On open document dynamic default selections

neelamsaroha157 — Fri, 05 May 2017 19:58:58 GMT

It is with trigger. I thought you don't want to do it with OnOpen so OnPostReload is another option.

Re: On open document dynamic default selections

Anonymous — Fri, 05 May 2017 20:11:59 GMT

How is it breaking your other functionality?

Re: On open document dynamic default selections

mayankraoka — Sat, 06 May 2017 07:13:26 GMT

Hi Wallo,

Thanks for reply.This is breaking my document chaining navigation part.Sheet navigation is not working properly.

Let me know if you required any further details.

Regards,

Mayank

Re: On open document dynamic default selections

Anonymous — Tue, 09 May 2017 16:55:05 GMT

A little more info would help. I don't know how an OnOpen trigger of select in field would hurt.

But if it does have you tried simply saving it with a search criteria something like

=max(MonthDate)

on your month date field?

I know expressions work as search criteria and I think this 'should' work for your situation, but I haven't tested it in your exact scenario.

Re: On open document dynamic default selections

Anonymous — Tue, 09 May 2017 17:03:43 GMT

Actually you would need something with Rank.

=Rank(MonthDate)=1

Re: On open document dynamic default selections

Anonymous — Tue, 09 May 2017 17:06:27 GMT

Actually you would need something with Rank.

=Rank(MonthDate)=1

Re: On open document dynamic default selections

Digvijay_Singh — Tue, 09 May 2017 17:23:24 GMT

You can pass parameters with URL but not sure how to do it dynamically using Max(month) etc..

Re: Passing Parameters in a URL and Document Chaining

Re: On open document dynamic default selections

mayankraoka — Tue, 09 May 2017 17:31:14 GMT

Hi Wallo,

Thank you for your reply.But when you are saying

Saving it with a search criteria something like

=max(MonthDate)

on your month date field?

How to achieve this,Can you please explain this.

Regards,

Mayank

Re: On open document dynamic default selections

Anonymous — Tue, 09 May 2017 17:42:39 GMT

Create a listbox with the field you want to filter against. And do a search like below.

It should give a result as you finish typing. Press Enter. (You can hide of delete the list box after if you like.)

Your current selections box will show this:

If you save your application with this filter on, then when it gets put on the server it 'should' survive a reload and pick the most recent month.

**Another option: You could also save add this as a bookmark. And then try a trigger to apply a bookmark, but that may give you the same issue you already have.

Re: On open document dynamic default selections

mayankraoka — Tue, 09 May 2017 17:44:17 GMT

Hi ,

I think your first option will work.Thanks I will check and update.

Regards,

Mayank

Re: On open document dynamic default selections

Anonymous — Tue, 09 May 2017 17:51:36 GMT

Good luck! Don't forget to type the '=' sign in the beginning!!!

Re: On open document dynamic default selections

mayankraoka — Tue, 16 May 2017 10:14:46 GMT

Hi Wallo,

This is working fine.Is there any way we can show month date field as correct in current selection as well.This is showing our expression currently which is =Rank([Month Date])=1,But i want it should display months value.

Regards,

Mayank

Re: On open document dynamic default selections

Anonymous — Tue, 16 May 2017 14:37:42 GMT

Unfortunately, not that I know of. I don't know of a way to have it show the value. Typically I would just use a text object or dynamic caption to capture the actual date value for display.