topic Re: Fix a field value for a QV document in QlikView

Fix a field value for a QV document

felcar2013 — Fri, 08 Mar 2013 10:45:24 GMT

do you know if it is possible to "fix" a value for the whole document? Lets say, i want always that the last timestamp is selected as default for all my document objects, so that i do not need to select it or i do not need to tell the user to always select that value.

thanks

Re: Fix a field value for a QV document

Anonymous — Fri, 08 Mar 2013 11:02:50 GMT

You can set up an action on opening of the document (Document properties > Triggers > On Open > Select in Field). You may need to put in an expression to assign it to =max(TimeStamp).

Jonathan

Re: Fix a field value for a QV document

somenathroy — Fri, 08 Mar 2013 11:16:46 GMT

One approach could be taken:

Declare a variable vMxTimeStamp = Max(TimeStamp)

And then have to include this variable in all document objects's expression like

Sum(TimeStamp={<$(=vMxTimeStamp)>} where applicable.

But this solution does work as long as a user session is live. When a user starts another session vMxTimeStamp is reset to Max(TimeStamp).

Regards,

Som

Re: Fix a field value for a QV document

felcar2013 — Fri, 08 Mar 2013 12:08:14 GMT

thanks for your answer! it was very useful