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: 
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) 😉