topic Re: Listbox with selected value that is based on a variable in App Development

Listbox with selected value that is based on a variable

jillwoodley — Tue, 14 Feb 2017 19:16:57 GMT

- is there such a thing? I have seen many posts on the subject and downloaded many different extensions. These extensions will only let you select a value - not an expression.

Can anyone help i'm sure there must be an answer

Re: Listbox with selected value that is based on a variable

marcus_sommer — Wed, 15 Feb 2017 12:03:16 GMT

You need to make your expression to a dimension with something like:

aggr(YourExpression, Dim1, Dim2)

Calculated Dimensions

- Marcus

Re: Listbox with selected value that is based on a variable

jillwoodley — Wed, 15 Feb 2017 15:52:43 GMT

Thanks Marcus for your help but i dont understand what you mean.

I have a list of dates [Internal Audit Date] as a dimension in a list box extension i have downloaded...:

then one of the options is always one selected value for which i have entered =max[Internal Audit Date] as below

this does nothing i have also tried using a variable vInternalAuditDate which doesnt work whereas if i enter 30/09/2016 it works - i assumed that as the box dosen't have a fx i cant use anything other than a value.

I have a page where it dosen't make sence to show the data for all dates at once, therfore i want to page to open with the last date, but allow the users to look back at the history. I don't really want to use the bookmark function.

Can you explain your answer a little more,

Many many thanks for your time

Jill

Re: Listbox with selected value that is based on a variable

marcus_sommer — Wed, 15 Feb 2017 16:14:14 GMT

Try it with: date(max([Internal Audit Date]), 'DD/MM/YYYY') to get a formatted date and not just a number.

- Marcus

Re: Listbox with selected value that is based on a variable

jillwoodley — Wed, 15 Feb 2017 16:34:14 GMT

No that dosen't seem to work either...

date(max([Internal Audit Date]), 'DD/MM/YYYY')

for some reason the YYYY seems to be underlined in red.

Would you expect to be able to enter an expression in a filed without the Fx

Re: Listbox with selected value that is based on a variable

marcus_sommer — Wed, 15 Feb 2017 17:02:35 GMT

Yes it could be that this field doesn't accept expressions - maybe you could use a variable which you creates within the script or maybe the Qlik Branch extension could also be used.

- Marcus

Re: Listbox with selected value that is based on a variable

jillwoodley — Wed, 15 Feb 2017 17:19:28 GMT

No it dosen't seem to accept variables either

Thanks for your help but this is not resolving my issue.

Do you know of anyother ways to have a page open with a predefined selection of the latest date?