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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Last Seletion on List box to show on Text Box

HI,

Anybody knows how can I show the last selection in a list box on a text box.

I have a list box that shows the months by name.

When I select several months such as Jul, Aug, Sep, I need the last value I choose to appear on a text box.

I have used =SubField(Concat(DISTINCT MonthName, ',', DateField), ',', 1) to show the first selected value and it is working perfect.

Now I am looking to show the last value.

Thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try -1 instead of 1

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Try -1 instead of 1

Not applicable
Author

Thxs!!!