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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator III
Creator III

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
alkesh_sharma
Creator III
Creator III

Try this as well.

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

stephenedberkg
Creator III
Creator III
Author

alkesh.sharma

  IT is also show same think only

stephenedberkg
Creator III
Creator III
Author

anbu1984


It is working fine but it show the month id only.

and i want two think bro

1.max(year) also

2.selected month sales

=num(Sum({$<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))}>}[Total Cost]),0.00)


this is my current sales expression

anbu1984
Master III
Master III

=If(GetFieldSelections(Month_field),GetFieldSelections(Month_field),Max(Year) & Max(Month_field))

stephenedberkg
Creator III
Creator III
Author

anbu1984


it show the 201412 for 2014 dec selection i want to show 2014-Dec like this

alkesh_sharma
Creator III
Creator III

=If(GetFieldSelections(Month_field),GetFieldSelections(Month_field),Max(Year) &'-' & MaxString(Month_field))

stephenedberkg
Creator III
Creator III
Author

alkesh.sharma


   But the multiple month selection is not working

alkesh_sharma
Creator III
Creator III

=IF(getfiledselectioncount(Month_field) = 0, Max(Year) & '-' & Maxstring(Month), Concate(GetFieldSelections(Year) & '- ' & MaxString(GetfieldSelection(Month)),'|'))


Don't just blindly copy paste the expression. read the expression and modify a lil to fir your needs.