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: 
katetsan
Creator
Creator

Container Label Expression with GetFieldSelections()

Hi Experts,

I'm trying to applied GetFieldSelections() in the expression of  Container label.

The outcome wasn't as I expected. Is there anyone could give me some hint?

Expression:

IF(GETFIELDSELECTIONS(YEAR)=0,  $(vLASTYEAR), $(vCURRENTYEAR))

 

The outcome always show $(vCURRENTYEAR) value.

Labels (4)
2 Solutions

Accepted Solutions
jwjackso
Specialist III
Specialist III

The GetFieldSelections  function returns a string, not a number.  I find it useful to display the results of the GetFieldSelections in a text box so that I can see what should be compared in the IF test.

View solution in original post

GregoireVG
Contributor II
Contributor II

Hi Katetsan,

I think the fonction you seek is GetSelectedCount(YEAR) 😉

View solution in original post

2 Replies
jwjackso
Specialist III
Specialist III

The GetFieldSelections  function returns a string, not a number.  I find it useful to display the results of the GetFieldSelections in a text box so that I can see what should be compared in the IF test.

GregoireVG
Contributor II
Contributor II

Hi Katetsan,

I think the fonction you seek is GetSelectedCount(YEAR) 😉