Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jillwoodley
Not applicable

Listbox with selected value that is based on a variable

- 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

6 Replies
marcus_sommer
Not applicable

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

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

aggr(YourExpression, Dim1, Dim2)

Calculated Dimensions

- Marcus

jillwoodley
Not applicable

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

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

marcus_sommer
Not applicable

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

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

- Marcus

jillwoodley
Not applicable

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

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

marcus_sommer
Not applicable

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

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

jillwoodley
Not applicable

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

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?