Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ardtkmn
Contributor
Contributor

filtering features

 
 
When I make more than 6 selections in the table, it says the unselected options on the label. I want to print "NOTE" at the beginning of the unselected options. EX: Not august, july..
how can I do it?
ardtkmn_0-1676380366408.png

Label Fx:

=if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Jan*'),'Jan, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Feb*'),'Feb, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Mar*'),'Mar, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Apr*'),'Apr, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*May*'),'May, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Jun*'),'Jun, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Jul*'),'Jul, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Aug*'),'Aug, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Sep*'),'Sep, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Oct*'),'Oct, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Nov*'),'Nov, ','')&
if(wildmatch(GetFieldSelections([TALEPOLUSTURMATARIHI.autoCalendar.Month]),'*Dec*'),'Dec, ','')

 

Labels (4)
1 Solution

Accepted Solutions
SerhanKaraer
Creator III
Creator III

Hello ardtkmn,

GetFieldSelections has a max values parameter. Default is 6. You can specify label with just one use of function like this:

 GetFieldSelections ([TALEPOLUSTURMATARIHI.autoCalendar.Month], ',', 100)

 

View solution in original post

1 Reply
SerhanKaraer
Creator III
Creator III

Hello ardtkmn,

GetFieldSelections has a max values parameter. Default is 6. You can specify label with just one use of function like this:

 GetFieldSelections ([TALEPOLUSTURMATARIHI.autoCalendar.Month], ',', 100)