topic Re: How to limit your data from load script for a particular location. in QlikView https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76873#M769293 <HTML><HEAD></HEAD><BODY><P>I guess, You can try with sheet level triggers by adding the actions to select the region of your interest(On Activate the sheet) . And add one more sheet level trigger (on Leaving the sheet) for clearing all selections.</P></BODY></HTML> Fri, 08 Jun 2018 19:16:41 GMT vikramv 2018-06-08T19:16:41Z How to limit your data from load script for a particular location. https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76869#M769289 <HTML><HEAD></HEAD><BODY><P>Dear all, I like to create a new sheet from the main sheet that shows only few of the locations. Grateful if you could let me know how I can limit the data from load script for a particular location.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76869#M769289 Anonymous 2020-11-25T16:16:04Z Re: How to limit your data from load script for a particular location. https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76870#M769290 <HTML><HEAD></HEAD><BODY><P>what is values of location?</P><P></P><P>could you please explain more?</P></BODY></HTML> Fri, 08 Jun 2018 17:44:59 GMT https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76870#M769290 Chanty4u 2018-06-08T17:44:59Z Re: How to limit your data from load script for a particular location. https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76871#M769291 <HTML><HEAD></HEAD><BODY><P>These are global dashboards but what I like to do is to do one for only AMERICAS. so the values are names of the locations. </P></BODY></HTML> Fri, 08 Jun 2018 17:48:58 GMT https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76871#M769291 Anonymous 2018-06-08T17:48:58Z Re: How to limit your data from load script for a particular location. https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76872#M769292 <HTML><HEAD></HEAD><BODY><P>So I like to duplicate the sheet into my own area and create one for only my sites that I am covering. As in the current status you need to filter and then add a bookmark etc. It is also not convenient to filter the sites and then out these sites you like to go into a particular location but then you lost the previous selection. And when sending to other parties they should only be able to see the sites relevant.</P><P></P><P><BR />I believe this should be possible by editing the Data Aggregation may be?</P></BODY></HTML> Fri, 08 Jun 2018 17:56:06 GMT https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76872#M769292 Anonymous 2018-06-08T17:56:06Z Re: How to limit your data from load script for a particular location. https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76873#M769293 <HTML><HEAD></HEAD><BODY><P>I guess, You can try with sheet level triggers by adding the actions to select the region of your interest(On Activate the sheet) . And add one more sheet level trigger (on Leaving the sheet) for clearing all selections.</P></BODY></HTML> Fri, 08 Jun 2018 19:16:41 GMT https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76873#M769293 vikramv 2018-06-08T19:16:41Z Re: How to limit your data from load script for a particular location. https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76874#M769294 <HTML><HEAD></HEAD><BODY><P>Thank you Vikram, but I did not understand. </P></BODY></HTML> Fri, 08 Jun 2018 19:43:11 GMT https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76874#M769294 Anonymous 2018-06-08T19:43:11Z Re: How to limit your data from load script for a particular location. https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76875#M769295 <HTML><HEAD></HEAD><BODY><P>I mean something similar to this </P><P><A href="https://community.qlik.com/thread/285261">Action on activate Sheet and leave Sheet</A></P></BODY></HTML> Fri, 08 Jun 2018 20:21:28 GMT https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76875#M769295 vikramv 2018-06-08T20:21:28Z Re: How to limit your data from load script for a particular location. https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76876#M769296 <HTML><HEAD></HEAD><BODY><P>Vikram, I'm afraid I did not mention that I am working on Qlik-sense Dev hub and we don't have the attached.options. </P></BODY></HTML> Fri, 08 Jun 2018 20:31:01 GMT https://community.qlik.com/t5/QlikView/How-to-limit-your-data-from-load-script-for-a-particular/m-p/76876#M769296 Anonymous 2018-06-08T20:31:01Z