Discussion board where members can get started with QlikView.
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!
For me this sounds as Adhoc, Hence you can simply
=SubStringCount('|' & Concat(distinct [Output Items], '|') & '|', '|Cost|')
View solution in original post
Not really sure - What you tried and trying here? Perhaps this
If([Output items]='Cost', 1,0)
Hello @saminea_ANZ !
Thank you for your suppot!
I would like to select multiple items as the output items... so I cannot use expression "=".
@saminea_ANZ , @Vegar
It went well! Thank you for your perfect answer!!!