Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this in that case:
=SubStringCount('|' & GetFieldSelections(dimension_1, '|', 10000) & '|', '|Level 4 Mgr Name|')
Try this:
=SubStringCount(Concat(DISTINCT dimension_1, '|'), 'Level 4 Mgr Name')
Not sure why you are using $Field? because $Field doesn't contain any value of Level 4 Mgr Name
Thanks Sunny
used this formula still i am not getting results - see attached qvw.
Vikas
Even if we use dimension_1 still not getting result.
?
Vikas
When I open you application, I am seeing this
Are you not seeing this?
I want when user select 1 and when user de-select 0 for ad-hoc reporting i want this function.
Viikas
May be this..
=if(GetSelectedCount(dimension_1)>0,
SubStringCount(Concat(DISTINCT dimension_1, '|'), 'Level 4 Mgr Name'),0)
Try this in that case:
=SubStringCount('|' & GetFieldSelections(dimension_1, '|', 10000) & '|', '|Level 4 Mgr Name|')
I think it might be better to use GetFieldSelections, rather than using the If with Concat here. Just my opinion