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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register 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 (1)
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'), ', ')