topic Re: Default Values for Document in QlikView

Default Values for Document

arusanah — Thu, 09 Apr 2015 15:39:38 GMT

HI There,

I need to set some default values for my Document :

My document is dynamic . All charts and reports are generated on selections . what I want is, when I open my app it should not display blank reports or charts, it should have some default values populated , how to do that?

Re: Default Values for Document

Karthik3 — Thu, 09 Apr 2015 16:00:25 GMT

You can do this in some ways:-

1. Select the selections you want and save the application as it is so that when you open the app those selections will be

2. GOTO Settings->DOcument Properties->Triggers and give actions for ONOpen document

I would 'Select In Field' action for the selections I want.

Re: Default Values for Document

arusanah — Tue, 14 Apr 2015 22:55:10 GMT

There is another way of doing this found it yesterday. .

Create a list box with that field . select one value and in general select as Always one selected option .

Don't know how I missed that part before

Re: Default Values for Document

Karthik3 — Wed, 15 Apr 2015 09:16:25 GMT

OK. Mark the question as answered if you got it solved.

Re: Default Values for Document

awhitfield — Wed, 15 Apr 2015 09:19:21 GMT

The only problem with this is that you will only be able to select 'one' value in the list box.

Andy

Re: Default Values for Document

arusanah — Wed, 15 Apr 2015 14:44:44 GMT

yes , true

what i needed as of now was when user opens a document he shoud not see a blank report . so i created a listbox for date and selected one date as always selected . I guess applying this condition on date solves problem otherwise we have to create separate list boxes with this condition .

Re: Default Values for Document

Karthik3 — Wed, 15 Apr 2015 14:52:59 GMT

What if you want the report for all the dates or just no selections on date .You have to clear the date filter to do this.

Re: Default Values for Document

giakoum — Wed, 15 Apr 2015 14:59:54 GMT

It would be better to create a bookmark so that OnOpen works both for IE plugin and the Ajax client

Re: Default Values for Document

arusanah — Wed, 15 Apr 2015 15:15:27 GMT

we can make selections as and when we need . The requirement was that the report shouldnt look blank when user opens it.

currently its a dynamic report and it just displays msg as select dimension and metrics , which user was not comfortable with.