Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

display multiple dynamic titles on selections made in list box

Hi All, need some assistance in displaying dynamic titles on selections made, for this I wrote =getcurrentselections(),

but the problem is I'm loading one date field in the format of 42060.... where i converted it to Date(PurgeChar([Field Name],'[]'),'DD-MMM')) but when selected this particular list box its showing up as number not in the date format,...how to write a condition to show up two or three fields in title....

Regards

krishna

1 Solution

Accepted Solutions
Not applicable
Author

Use =GetFieldSelection(FIELD,';')&' '&GetFieldSelection(ANOTHERFIELD,';')

View solution in original post

4 Replies
amit_saini
Master III
Master III

Hi Krishna,

Try something like below:

=Date(Date,'MM-DD-YYYY') &chr(32)&if(GetSelectedCount(Plant)>0,'- '&GetFieldSelections(Plant))

Thanks,

AS

Not applicable
Author

Thanks Amit, I made it to appear for date thing, but how about other selection in list box2.

I would like to add more in detail here ,suppose i have  list box1, list box2. I want them to get displayed both on title..side by side .dynamic.PNGin the image i want another field name to be displayed next to the date.

Regards

Krishna

Not applicable
Author

Use =GetFieldSelection(FIELD,';')&' '&GetFieldSelection(ANOTHERFIELD,';')

amit_saini
Master III
Master III

Try like below:

=Date(Date,'MM-DD-YYYY') &chr(32)&if(GetSelectedCount(Plant)>0)&' '&if(GetSelectedCount(Another_Field )>0)

You just need to use &' '& between two conditions.

Thanks,

AS