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: 
alanwong1178
Contributor III
Contributor III

getfieldselection date value

Hi All,

I would like to use getfieldselection in set analysis.  I have looked for solution in community to turn to date mmmdd format as below. But it doesn't work

 

date#(GetFieldSelections([orderdate]),'MMMdd')

like order date = 10/21/2021, 11/27/2021 , I would like to get  Oct21 , Nov27

Labels (2)
2 Replies
salonicdk28
Creator II
Creator II

Hi,

Please try using this-

=Date(GetFieldSelections([orderdate]),'MMMDD')

Vegar
MVP
MVP

The GetfieldSelections() returns a string describing your selection, it does not return an array of values.  It will be hard to format each of these, there is also a default limit to the amount of selection listed before it starts to return "X out of 1234".

I suggest you either create a field with the format 'MMMDD' and do the selections on that field. Or if the check for selection not important, but you just want a list of available values then you could use concat()  instead.  Maybe like this?

=concat(Distinct Date([orderdate],'MMMDD'), ', ')