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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Tool_Tip
Creator III
Creator III

Single value in text

Dear all

From sample table we want to display only product which is selected in sheet. We are using GetFieldSelections(Product) but it is displaying multiple product if we select multiple product instead we want to display only one product at a time in text box in sheet.

We do not want to use "Always one selected value" option for Product field.

MySalesData:
LOAD * INLINE [
OrderID, Product, Quantity, Price
101, "Laptop", 2, 1200
102, "Mouse", 5, 25
103, "Keyboard", 3, 75
104, "Monitor", 1, 300
105, "Webcam", 4, 50
];

Labels (1)
3 Replies
Amit_Prajapati
Creator
Creator

Hi @Tool_Tip  , How do we determine which value to display when multiple selections are made? We need to define the logic or rule that decides the priority or condition for display. Once that definition is clear, we can apply the same logic in our implementation.

Tool_Tip
Creator III
Creator III
Author

Hi Amit,

For now lets consider, first value from multiple selection.

Amit_Prajapati
Creator
Creator

Hi @Tool_Tip  , You can use the following string function to achieve the desired result in this case.

SubField(GetFieldSelections(Name), ',', 1)