Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Creating a variable using GetSelectionField

Dear All, I have a month field dimension MONTH_STRING=Date(Date#([Data.autoCalendar.Month],'MMM'),'MMMM') What I would like to do is to create a variable for MONTH_STRING that allows me to select one or more months. I tryied to create a variable using GetSelectionField such as: vMonth=GetFieldSelections((Date(Date#([Data.autoCalendar.Month],'MMM'),'MMMM')),',',12) but it doesn't seam to work. Can you guys please help me understand how can I write a variable for MONTH_STRING that allows me to select one or more than one month? Thanks in advance

4 Replies

GetFieldSelections only uses FieldName... manipulations like Date() and Date#() won't work... may be use Concat instead with GetSelectedCount() to check if selection has been made or not

If(GetSelectedCount([Data.autoCalendar.Month]) > 0,
Concat(DISTINCT Date(Date#([Data.autoCalendar.Month], 'MMM'), 'MMMM'), ',')
)

 

Highlighted
Contributor III
Contributor III

This is not working 😞

Highlighted

Would you be able to share a sample where we can see the issue?

Highlighted
Contributor III
Contributor III

I don't have data to show you. What I can show you is what I am trying to do with the MONTH_STRING field I have create.

I have insert this is field in a filter panel:

 Month.PNG

and I want to be able (with a variable) to display the month/months that I have selected in this filter panel

Text area.PNG