topic how to restrict data each each tab in a report in QlikView https://community.qlik.com/t5/QlikView/how-to-restrict-data-each-each-tab-in-a-report/m-p/215775#M589741 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a dimension which has 3 values in it - "UK", "USA", "Other"</P><P>I want to have a trellis report for each dimension but to have each report on a separate tab related to the Dimension.</P><P>Is there a filter that can be automatically applied to a Tab so that it only shows data related to one Dimension - I do not want the users to have to select the value from the Dimension.</P><P>Cheers</P><P>David</P></BODY></HTML> Tue, 06 Jul 2010 14:59:09 GMT 2010-07-06T14:59:09Z how to restrict data each each tab in a report https://community.qlik.com/t5/QlikView/how-to-restrict-data-each-each-tab-in-a-report/m-p/215775#M589741 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a dimension which has 3 values in it - "UK", "USA", "Other"</P><P>I want to have a trellis report for each dimension but to have each report on a separate tab related to the Dimension.</P><P>Is there a filter that can be automatically applied to a Tab so that it only shows data related to one Dimension - I do not want the users to have to select the value from the Dimension.</P><P>Cheers</P><P>David</P></BODY></HTML> Tue, 06 Jul 2010 14:59:09 GMT https://community.qlik.com/t5/QlikView/how-to-restrict-data-each-each-tab-in-a-report/m-p/215775#M589741 2010-07-06T14:59:09Z how to restrict data each each tab in a report https://community.qlik.com/t5/QlikView/how-to-restrict-data-each-each-tab-in-a-report/m-p/215776#M589742 <HTML><HEAD></HEAD><BODY><P>Two approaches I'm thinking of. First, you could use set analysis to override the user selection in that field for that particular report on that tab. Something like this on the UK tab:</P><P style="padding-left:30px;">sum({&lt;Country={'UK'}&gt;} Sales)</P><P>Second, you could actually select the value when they go to the tab. In the sheet properties, Triggers tab, OnActivateSheet, add an action to make a selection in field Country, search string UK.</P></BODY></HTML> Wed, 07 Jul 2010 00:13:50 GMT https://community.qlik.com/t5/QlikView/how-to-restrict-data-each-each-tab-in-a-report/m-p/215776#M589742 johnw 2010-07-07T00:13:50Z how to restrict data each each tab in a report https://community.qlik.com/t5/QlikView/how-to-restrict-data-each-each-tab-in-a-report/m-p/215777#M589743 <HTML><HEAD></HEAD><BODY><P>Perfect - exactly what I was looking for.</P><P></P><P>Thanks for your help</P></BODY></HTML> Wed, 07 Jul 2010 16:57:39 GMT https://community.qlik.com/t5/QlikView/how-to-restrict-data-each-each-tab-in-a-report/m-p/215777#M589743 2010-07-07T16:57:39Z