Hello guys, I'm new to qlikview.
On my straight table chart, I would like to show only the items which selected as an output item.
(Selected in the listbox -> Reflected to the Straight table)
I used "GetField Selections" expression for the dimentions of straight table, but it doesn't work properly.
As the following screenshot, when I select an item "Unit Cost", an item "Cost" also displayed in the straight table due to t a part of item name is same.
=GetFieldSelections([Output items],',',110)like '*Cost*'
=GetFieldSelections([Output items],',',110)like '*Unit Cost*'
Is it possible to distinguish between "Cost" and "Unit Cost"?
Thank you for your support!
Solved! Go to Solution.