Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ledi12
Contributor II
Contributor II

Get available values from field, based on current selections

Hi.

 

I have a table with 4columns.

id, currency, company, customer

 

Company & customer can have only one currency.

 

It's possible that all selected companies & customers will have the same currency, so currency field will have only one value which is not greyed out.

I need this information for the condition in my expression. How can I solve it?

Labels (4)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

GetFieldSelections(currency)

if there are more than one, separate them with commas by GetFieldSelections(currency, ',')

View solution in original post

1 Reply
Lisa_P
Employee
Employee

GetFieldSelections(currency)

if there are more than one, separate them with commas by GetFieldSelections(currency, ',')