Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mayankraoka
Specialist
Specialist

On open document dynamic default selections

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

15 Replies
neelamsaroha157
Specialist II
Specialist II

You can do it with OnPostReload.

mayankraoka
Specialist
Specialist
Author

Hi Neelam,

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

Regards,

Mayank

neelamsaroha157
Specialist II
Specialist II

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

Anonymous
Not applicable

How is it breaking your other functionality?

mayankraoka
Specialist
Specialist
Author

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

Anonymous
Not applicable

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.

Anonymous
Not applicable

Actually you would need something with Rank. 

=Rank(MonthDate)=1

Anonymous
Not applicable

Actually you would need something with Rank.

=Rank(MonthDate)=1

Digvijay_Singh

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