https://community.qlik.com/t5/App-Development/Dynamic-Report-and-Alternate-State/m-p/1707583#M54287 <P>Hi,</P><P>I have a request for a comparative analysis with dynamic reports.</P><P>So I created 2 groups of filters with alternate states, and two tables.</P><P>Each table is linked to a state.</P><P>I would like to have the list of dimensions and measures that the user selects, to serve both tables.</P><P>I guess I have to modify the show column condition, but not sure how to do it.&nbsp;</P><P>This is an example of a dimension condition:</P><P>=SubStringCount(Concat( DISTINCT '|' &amp;[_DimNo_CA_1] &amp; '|'), '|5|') and GetSelectedCount([_Dim_CA_1]) &gt;0</P><P>Any idea how to do it?</P><P>Thanks!</P> Sat, 16 Nov 2024 18:33:08 GMT dana 2024-11-16T18:33:08Z https://community.qlik.com/t5/App-Development/Dynamic-Report-and-Alternate-State/m-p/1707583#M54287 <P>Hi,</P><P>I have a request for a comparative analysis with dynamic reports.</P><P>So I created 2 groups of filters with alternate states, and two tables.</P><P>Each table is linked to a state.</P><P>I would like to have the list of dimensions and measures that the user selects, to serve both tables.</P><P>I guess I have to modify the show column condition, but not sure how to do it.&nbsp;</P><P>This is an example of a dimension condition:</P><P>=SubStringCount(Concat( DISTINCT '|' &amp;[_DimNo_CA_1] &amp; '|'), '|5|') and GetSelectedCount([_Dim_CA_1]) &gt;0</P><P>Any idea how to do it?</P><P>Thanks!</P> Sat, 16 Nov 2024 18:33:08 GMT https://community.qlik.com/t5/App-Development/Dynamic-Report-and-Alternate-State/m-p/1707583#M54287 dana 2024-11-16T18:33:08Z