SubStringCount function issue

[vikasmahajan]

Dear all,

I have  inline load and loading dimensions into table , and applying  =SubStringCount(Concat($Field, '|'), 'Level 4 Mgr Name')

it giving me zero o/p but it should give 1 for ad-hoc reporting.

QVW is attached .

Base on selection in list  o/p should  0 /1

Thanks

Vikas

[sunny_talwar]

Try this:

=SubStringCount(Concat(DISTINCT dimension_1, '|'), 'Level 4 Mgr Name')

[sunny_talwar]

Not sure why you are using $Field? because $Field doesn't contain any value of Level 4 Mgr Name

[vikasmahajan]

Thanks Sunny

used this formula still i am not getting results - see attached qvw.

Vikas

[vikasmahajan]

Even if we use dimension_1 still not getting result.

?

Vikas

[sunny_talwar]

When I open you application, I am seeing this

Are you not seeing this?

[vikasmahajan]

I want when user select 1 and when user de-select 0 for ad-hoc reporting i want this function.

Viikas

[settu_periasamy]

May be this..

=if(GetSelectedCount(dimension_1)>0,

SubStringCount(Concat(DISTINCT dimension_1, '|'), 'Level 4 Mgr Name'),0)

[sunny_talwar · Accepted solution]

Try this in that case:

=SubStringCount('|' & GetFieldSelections(dimension_1, '|', 10000) & '|', '|Level 4 Mgr Name|')

[sunny_talwar]

I think it might be better to use GetFieldSelections, rather than using the If with Concat here. Just my opinion