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

Qlik Filterin Features

When I make more than 6 selections in the table, it says the unselected options on the label. I want to print "NOT" at the beginning of the unselected options. EX: Not august, july..
how can I do it?
ardtkmn_1-1676380592492.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, ','')

ardtkmn_0-1676380577697.png

 

 
Labels (5)
1 Solution

Accepted Solutions
vikasmahajan

Hi,

Select July,Aug those you wanted to select and  select excluded option :

vikasmahajan_0-1684411121552.png

Hope this will resolve your issue.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

1 Reply
vikasmahajan

Hi,

Select July,Aug those you wanted to select and  select excluded option :

vikasmahajan_0-1684411121552.png

Hope this will resolve your issue.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.