Conditional Show for Sheet on Field Selection

[MalcolmCICWF]

I have a report where I have 3 different input files that share 13 fields between them. The other fields are all unique to that input file. In the QV report, I have a tab with the shared criteria and some main charts, but I have3 other tabs with additional breakout reporting and fields realted to that specific input file. I have seen it before, but was unable to find a related topic in the QV Community for what I need.

I only want a sheet to show on the condition that that tab is selected in the ComplaintsTab field on the Shared sheet. I could not figure out the right expression for each of the 3 tabs to make them show. When I select Account Support on the Shared Criteria sheet, I want the Account Support sheet to show.

I thought it would be as easy as an expression saying if (ComplaintsTab='Account Support') as the condition show for the sheet...

I attached a mock version of the report for reference if anyone could help me figure this out.

[Anonymous · Accepted solution]

GetFieldSelections(ComplaintsTab) = 'Account Support'

and in the same for all another sheets

for the sheet activating, you can add trigger over the ConplaintsTab field:

"OnSelect" ->Activate Next Sheet

sample attached

[tresesco]

May be like attached sample:

[#4]

Hi,

you may use the below condition in the Conditional Show field of the particular sheet.

=SubStringCount('|' & Concat(distinct [ComplaintsTab], '|') & '|', '|Account Support|')

It should work

thanks.

[MalcolmCICWF]

Thanks, idk why I couldnt find something along this lines, much simpler than I thought. How to you get to the field trigger settings?