topic Re: Set analysis for Commercial KPI's in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-for-Commercial-KPI-s/m-p/1388448#M805597 <HTML><HEAD></HEAD><BODY><P>May be as below: (I am using version 12)</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181660_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 31 Oct 2017 16:08:15 GMT trdandamudi 2017-10-31T16:08:15Z Set analysis for Commercial KPI's https://community.qlik.com/t5/QlikView/Set-analysis-for-Commercial-KPI-s/m-p/1388447#M805596 <HTML><HEAD></HEAD><BODY><P>I am currently building a commercial KPI dashboard.</P><P></P><P>What I want to do is set a number of charts that only utilise restriced selections from one column called 'DIVISION'</P><P></P><P>DIVISION ranges from 1-22 so I am trying to get the same chart, but each one to only choose from a set number of divisions.</P><P></P><P>Example:</P><P><SPAN style="text-decoration: underline;">DIV</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="text-decoration: underline;">CHART 1</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="text-decoration: underline;"> CHART 2</SPAN></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DIV 1 &amp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DIV 2 Only</P><P>2</P><P>3</P><P>4</P><P>5</P><P>6</P><P></P><P></P><P></P><P>The expression can be changed as this isn't the issue what is being calculated, it is the data that is being considered in all charts currently that need restricting.</P><P></P><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-analysis-for-Commercial-KPI-s/m-p/1388447#M805596 Anonymous 2020-11-25T16:16:04Z Re: Set analysis for Commercial KPI's https://community.qlik.com/t5/QlikView/Set-analysis-for-Commercial-KPI-s/m-p/1388448#M805597 <HTML><HEAD></HEAD><BODY><P>May be as below: (I am using version 12)</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181660_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 31 Oct 2017 16:08:15 GMT https://community.qlik.com/t5/QlikView/Set-analysis-for-Commercial-KPI-s/m-p/1388448#M805597 trdandamudi 2017-10-31T16:08:15Z Re: Set analysis for Commercial KPI's https://community.qlik.com/t5/QlikView/Set-analysis-for-Commercial-KPI-s/m-p/1388449#M805598 <HTML><HEAD></HEAD><BODY><P>This seems it will work with some small amendments,</P><P></P><P>Thanks Thirimala <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Tue, 31 Oct 2017 16:12:46 GMT https://community.qlik.com/t5/QlikView/Set-analysis-for-Commercial-KPI-s/m-p/1388449#M805598 Anonymous 2017-10-31T16:12:46Z Re: Set analysis for Commercial KPI's https://community.qlik.com/t5/QlikView/Set-analysis-for-Commercial-KPI-s/m-p/1388450#M805599 <HTML><HEAD></HEAD><BODY><P>You are welcome...</P></BODY></HTML> Tue, 31 Oct 2017 16:13:53 GMT https://community.qlik.com/t5/QlikView/Set-analysis-for-Commercial-KPI-s/m-p/1388450#M805599 trdandamudi 2017-10-31T16:13:53Z