topic About the expression GetFieldSelections in QlikView

About the expression GetFieldSelections

Yuhka — Sat, 16 Nov 2024 21:01:34 GMT

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.

*Enable Consitional:

=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!

Re: About the expression GetFieldSelections

saminea_ANZ — Thu, 18 Apr 2019 01:52:35 GMT

Not really sure - What you tried and trying here? Perhaps this

If([Output items]='Cost', 1,0)

Re: About the expression GetFieldSelections

Yuhka — Thu, 18 Apr 2019 02:10:27 GMT

Hello @saminea_ANZ !

Thank you for your suppot!

I would like to select multiple items as the output items... so I cannot use expression "=".

Re: About the expression GetFieldSelections

saminea_ANZ — Thu, 18 Apr 2019 02:29:10 GMT

For me this sounds as Adhoc, Hence you can simply

=SubStringCount('|' & Concat(distinct [Output Items], '|') & '|', '|Cost|')

Re: About the expression GetFieldSelections

Vegar — Thu, 18 Apr 2019 04:44:50 GMT

I have not used you approach my self, but is it not possible to do like this?

=GetFieldSelections([Output items],',',110) = 'Cost'

If it is not then the solution below should give you your desired result.

SubStringCount( Concat( DISTINCT '|' & [Output items] & '|'), '|Cost|')
AND
GetSelectedCount ([Output items]) > 0

Re: About the expression GetFieldSelections

Yuhka — Thu, 18 Apr 2019 06:38:54 GMT

@saminea_ANZ , @Vegar

It went well! Thank you for your perfect answer!!!