Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator II
Creator II

Multiple Month Selection

If i select the multiple month i want to show the label for all selected month.

Eg:

I select the month  jan, feb ,march mean i want to show that three month are selected in expression label

17 Replies
anbu1984
Master III
Master III

Set to this expr in Expression label

=GetFieldSelections(Month_field)

PrashantSangle

Hi,

Use Concat()

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
alkesh_sharma
Creator III
Creator III

Try This

=Concate(GetFieldSelections(Month_field),'|')

stephenedberkg
Creator II
Creator II
Author

anbu1984

            

                i got the answer but if i am not select any of month mean i want to show the last month.

anbu1984
Master III
Master III

If(IsNull(GetFieldSelections(Month_field)),'Dec',GetFieldSelections(Month_field))

stephenedberkg
Creator II
Creator II
Author

aanbu1984

i want to show Max(month) only because my sales last month is November mean what can i do?

alkesh_sharma
Creator III
Creator III

=IF(getfiledselectioncount(Month_field) = 0, Max(Month), Concate(GetFieldSelections(Month_field),'|'))

anbu1984
Master III
Master III

If(GetFieldSelections(Month_field),GetFieldSelections(Month_field),Max(Month_field))

stephenedberkg
Creator II
Creator II
Author

alkesh.sharma

It show only the selected month only not show the max(Month)