Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Specialist
Specialist

Show two text different with getfieldselections

Hi, 

 

I have a table and  i want to show the selections entered by user  in subtible of table. 

 

I try this expression : 

=IF(GetFieldSelections(ICODE) >0,'Code: '& GetFieldSelections(CODE)
OR
GetFieldSelections(VERSION) >0,'Version: '& GetFieldSelections(VERSION)
)

 

But the result that is returned is "-1" instead of T6012 for Codeet MONTH for Version

Labels (2)
3 Replies
marcus_sommer
MVP
MVP

Try it with:

IF(GetSelectedCount(ICODE) >0,'Code: '& GetFieldSelections(CODE))

or maybe with getcurrentselections().

- Marcus

jmialoundama
Specialist
Specialist
Author

Hi Marcus, 

That's not what I want to do.

The formula you propose will only return the code.

In my case, I want the getfieldselections to return the code selected by the user AND the version that the user will select

marcus_sommer
MVP
MVP

Maybe:

IF(GetSelectedCount(ICODE) >0,'Code: '& GetFieldSelections(CODE))
& chr(10) &
IF(GetSelectedCount(VERSION) >0,'VERSION: '& GetFieldSelections(VERSION))