topic Re: Conditional Show for Sheet on Field Selection in QlikView

Conditional Show for Sheet on Field Selection

MalcolmCICWF — Thu, 18 Sep 2014 21:28:27 GMT

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.

Re: Conditional Show for Sheet on Field Selection

Anonymous — Fri, 19 Sep 2014 05:52:05 GMT

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

Re: Conditional Show for Sheet on Field Selection

tresB — Fri, 19 Sep 2014 06:05:15 GMT

May be like attached sample:

Re: Conditional Show for Sheet on Field Selection

Fri, 19 Sep 2014 06:21:03 GMT

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.

Re: Conditional Show for Sheet on Field Selection

MalcolmCICWF — Fri, 19 Sep 2014 13:59:01 GMT

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