https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1837952#M69263 <P>Hi Experts,</P><P>I have a requirement to display the KPI on dimension value.</P><P>For example we have sales orders and its details information on data set we need to display the KPI value</P><P>like :</P><P>&nbsp;</P><P>=Num(Count(Distinct{&lt;Ciritical_Order={'YES'}&gt;} [Sales Order ID]))&nbsp; its showing some value&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Correct_Answer_0-1632226717202.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/62468iA2BE2BFFF10C3FC9/image-size/medium?v=v2&amp;px=400" role="button" title="Correct_Answer_0-1632226717202.png" alt="Correct_Answer_0-1632226717202.png" /></span></P><P>&nbsp;</P><P>While clicking on this KPI on Qliksense it should display the only&nbsp;</P><P>42 orders on below details table like&nbsp;</P><P>Detail table:</P><TABLE><TBODY><TR><TD>Customer</TD><TD>Sales Order ID</TD><TD>Ciritical_Order</TD><TD>ShipDate</TD><TD>Product</TD><TD>Sales</TD><TD>Quantity</TD></TR><TR><TD>Curtis, Liu</TD><TD>SO61145</TD><TD>YES</TD><TD>1/7/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Samuel, Ross</TD><TD>SO62601</TD><TD>YES</TD><TD>1/30/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Troy, Mehta</TD><TD>SO62654</TD><TD>YES</TD><TD>1/31/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Dominic, Madan</TD><TD>SO62727</TD><TD>YES</TD><TD>2/1/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Colin, He</TD><TD>SO62816</TD><TD>YES</TD><TD>2/2/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Brad, Oliver</TD><TD>SO62776</TD><TD>YES</TD><TD>2/2/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Natalie, Diaz</TD><TD>SO62924</TD><TD>YES</TD><TD>2/4/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Roger, Harui</TD><TD>SO63036</TD><TD>YES</TD><TD>2/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Hailey, Morgan</TD><TD>SO63054</TD><TD>YES</TD><TD>2/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Corey, Lal</TD><TD>SO63059</TD><TD>YES</TD><TD>2/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Krystal, Zheng</TD><TD>SO64091</TD><TD>YES</TD><TD>2/20/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Cynthia, Rodriguez</TD><TD>SO64057</TD><TD>YES</TD><TD>2/20/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Todd, Zheng</TD><TD>SO64140</TD><TD>YES</TD><TD>2/21/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Martin, Suri</TD><TD>SO64183</TD><TD>YES</TD><TD>2/22/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Ruben, Suarez</TD><TD>SO64434</TD><TD>YES</TD><TD>2/25/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Thomas, Hill</TD><TD>SO64436</TD><TD>YES</TD><TD>2/25/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Rafael, Shen</TD><TD>SO64464</TD><TD>YES</TD><TD>2/26/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Lisa, Cai</TD><TD>SO64592</TD><TD>YES</TD><TD>2/27/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>April, Andersen</TD><TD>SO65835</TD><TD>YES</TD><TD>3/17/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Brenda, Stone</TD><TD>SO65888</TD><TD>YES</TD><TD>3/18/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Bonnie, Lal</TD><TD>SO65917</TD><TD>YES</TD><TD>3/18/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Ashley, Henderson</TD><TD>SO66040</TD><TD>YES</TD><TD>3/20/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Rafael, Lin</TD><TD>SO66326</TD><TD>YES</TD><TD>3/25/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Samantha, Jenkins</TD><TD>SO66448</TD><TD>YES</TD><TD>3/27/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Dana, Diaz</TD><TD>SO66573</TD><TD>YES</TD><TD>3/29/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Fernando, Thomas</TD><TD>SO67097</TD><TD>YES</TD><TD>4/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Angela, Powell</TD><TD>SO67506</TD><TD>YES</TD><TD>4/11/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Margaret, Ye</TD><TD>SO67547</TD><TD>YES</TD><TD>4/11/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Miguel, Green</TD><TD>SO67690</TD><TD>YES</TD><TD>4/13/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Brittney, Hu</TD><TD>SO68083</TD><TD>YES</TD><TD>4/19/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Jocelyn, Gonzales</TD><TD>SO68164</TD><TD>YES</TD><TD>4/21/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Barbara, Nara</TD><TD>SO68276</TD><TD>YES</TD><TD>4/23/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Roger, Zeng</TD><TD>SO68312</TD><TD>YES</TD><TD>4/23/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Frank, Gomez</TD><TD>SO68623</TD><TD>YES</TD><TD>4/27/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Jeremiah, Russell</TD><TD>SO68690</TD><TD>YES</TD><TD>4/29/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Beth, Moreno</TD><TD>SO68866</TD><TD>YES</TD><TD>5/1/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Claudia, Holt</TD><TD>SO68897</TD><TD>YES</TD><TD>5/2/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>James, Parker</TD><TD>SO69123</TD><TD>YES</TD><TD>5/5/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Fernando, Barnes</TD><TD>SO69182</TD><TD>YES</TD><TD>5/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Donald, Martinez</TD><TD>SO69201</TD><TD>YES</TD><TD>5/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Autumn, Zhang</TD><TD>SO69596</TD><TD>YES</TD><TD>5/9/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can anyone kindly help me with the possibilities..</P><P>&nbsp;</P><P>Thanks in advance ...</P><P>&nbsp;</P> Tue, 21 Sep 2021 12:19:14 GMT Correct_Answer 2021-09-21T12:19:14Z https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1837952#M69263 <P>Hi Experts,</P><P>I have a requirement to display the KPI on dimension value.</P><P>For example we have sales orders and its details information on data set we need to display the KPI value</P><P>like :</P><P>&nbsp;</P><P>=Num(Count(Distinct{&lt;Ciritical_Order={'YES'}&gt;} [Sales Order ID]))&nbsp; its showing some value&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Correct_Answer_0-1632226717202.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/62468iA2BE2BFFF10C3FC9/image-size/medium?v=v2&amp;px=400" role="button" title="Correct_Answer_0-1632226717202.png" alt="Correct_Answer_0-1632226717202.png" /></span></P><P>&nbsp;</P><P>While clicking on this KPI on Qliksense it should display the only&nbsp;</P><P>42 orders on below details table like&nbsp;</P><P>Detail table:</P><TABLE><TBODY><TR><TD>Customer</TD><TD>Sales Order ID</TD><TD>Ciritical_Order</TD><TD>ShipDate</TD><TD>Product</TD><TD>Sales</TD><TD>Quantity</TD></TR><TR><TD>Curtis, Liu</TD><TD>SO61145</TD><TD>YES</TD><TD>1/7/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Samuel, Ross</TD><TD>SO62601</TD><TD>YES</TD><TD>1/30/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Troy, Mehta</TD><TD>SO62654</TD><TD>YES</TD><TD>1/31/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Dominic, Madan</TD><TD>SO62727</TD><TD>YES</TD><TD>2/1/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Colin, He</TD><TD>SO62816</TD><TD>YES</TD><TD>2/2/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Brad, Oliver</TD><TD>SO62776</TD><TD>YES</TD><TD>2/2/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Natalie, Diaz</TD><TD>SO62924</TD><TD>YES</TD><TD>2/4/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Roger, Harui</TD><TD>SO63036</TD><TD>YES</TD><TD>2/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Hailey, Morgan</TD><TD>SO63054</TD><TD>YES</TD><TD>2/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Corey, Lal</TD><TD>SO63059</TD><TD>YES</TD><TD>2/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Krystal, Zheng</TD><TD>SO64091</TD><TD>YES</TD><TD>2/20/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Cynthia, Rodriguez</TD><TD>SO64057</TD><TD>YES</TD><TD>2/20/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Todd, Zheng</TD><TD>SO64140</TD><TD>YES</TD><TD>2/21/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Martin, Suri</TD><TD>SO64183</TD><TD>YES</TD><TD>2/22/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Ruben, Suarez</TD><TD>SO64434</TD><TD>YES</TD><TD>2/25/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Thomas, Hill</TD><TD>SO64436</TD><TD>YES</TD><TD>2/25/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Rafael, Shen</TD><TD>SO64464</TD><TD>YES</TD><TD>2/26/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Lisa, Cai</TD><TD>SO64592</TD><TD>YES</TD><TD>2/27/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>April, Andersen</TD><TD>SO65835</TD><TD>YES</TD><TD>3/17/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Brenda, Stone</TD><TD>SO65888</TD><TD>YES</TD><TD>3/18/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Bonnie, Lal</TD><TD>SO65917</TD><TD>YES</TD><TD>3/18/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Ashley, Henderson</TD><TD>SO66040</TD><TD>YES</TD><TD>3/20/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Rafael, Lin</TD><TD>SO66326</TD><TD>YES</TD><TD>3/25/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Samantha, Jenkins</TD><TD>SO66448</TD><TD>YES</TD><TD>3/27/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Dana, Diaz</TD><TD>SO66573</TD><TD>YES</TD><TD>3/29/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Fernando, Thomas</TD><TD>SO67097</TD><TD>YES</TD><TD>4/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Angela, Powell</TD><TD>SO67506</TD><TD>YES</TD><TD>4/11/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Margaret, Ye</TD><TD>SO67547</TD><TD>YES</TD><TD>4/11/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Miguel, Green</TD><TD>SO67690</TD><TD>YES</TD><TD>4/13/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Brittney, Hu</TD><TD>SO68083</TD><TD>YES</TD><TD>4/19/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Jocelyn, Gonzales</TD><TD>SO68164</TD><TD>YES</TD><TD>4/21/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Barbara, Nara</TD><TD>SO68276</TD><TD>YES</TD><TD>4/23/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Roger, Zeng</TD><TD>SO68312</TD><TD>YES</TD><TD>4/23/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Frank, Gomez</TD><TD>SO68623</TD><TD>YES</TD><TD>4/27/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Jeremiah, Russell</TD><TD>SO68690</TD><TD>YES</TD><TD>4/29/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Beth, Moreno</TD><TD>SO68866</TD><TD>YES</TD><TD>5/1/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Claudia, Holt</TD><TD>SO68897</TD><TD>YES</TD><TD>5/2/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>James, Parker</TD><TD>SO69123</TD><TD>YES</TD><TD>5/5/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Fernando, Barnes</TD><TD>SO69182</TD><TD>YES</TD><TD>5/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Donald, Martinez</TD><TD>SO69201</TD><TD>YES</TD><TD>5/6/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR><TR><TD>Autumn, Zhang</TD><TD>SO69596</TD><TD>YES</TD><TD>5/9/2013</TD><TD>All-Purpose Bike Stand</TD><TD>159.00</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can anyone kindly help me with the possibilities..</P><P>&nbsp;</P><P>Thanks in advance ...</P><P>&nbsp;</P> Tue, 21 Sep 2021 12:19:14 GMT https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1837952#M69263 Correct_Answer 2021-09-21T12:19:14Z https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1837956#M69264 <P>Vizlib's KPI has actions that can be tied to it.</P><P>Native QSense KPI can link to another sheet.&nbsp; You can create a Critical Orders Detail sheet with your table you mentioned and limit to just those critical orders by set analysis or putting an action on your Critical Orders Detail sheet to select&nbsp;<SPAN>Ciritical_Order={'YES'}.</SPAN></P> Tue, 21 Sep 2021 12:26:54 GMT https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1837956#M69264 stevejoyce 2021-09-21T12:26:54Z https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1838009#M69271 <P>Hi Stevejoyce,</P><P>Thanks for your response.</P><P>Can you please elaborate which Vizlib KPI global action will fulfil my requirement and how to use it to filter the data at dashboard level by using KPI clicks.</P><P>I am new to the Vizlib extension.</P><P>Thanks,</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 21 Sep 2021 14:03:28 GMT https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1838009#M69271 Correct_Answer 2021-09-21T14:03:28Z https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1838054#M69280 <P>Pick Action:&nbsp; Selection in Field</P><P>Field:&nbsp;<SPAN>Ciritical_Order</SPAN></P><P><SPAN>FieldValue:&nbsp; YES</SPAN></P> Tue, 21 Sep 2021 15:42:44 GMT https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1838054#M69280 stevejoyce 2021-09-21T15:42:44Z https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1838288#M69310 <P>Hi Stevejoyce,</P><P>Thanks for your response.</P><P>After applying the given changes in my dashboard like&nbsp;</P><P>Pick Action:&nbsp; Selection in Field</P><P>Field:&nbsp;<SPAN>Ciritical_Order</SPAN></P><P><SPAN>FieldValue:&nbsp; YES&nbsp;</SPAN></P><P><SPAN>After clicking this kpi with above global action then target table object is not changing.</SPAN></P><P><SPAN>Is there any setting needs to apply for target object.</SPAN></P><P><SPAN>Thanks</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P><SPAN>&nbsp;</SPAN></P><P>&nbsp;</P> Wed, 22 Sep 2021 10:25:28 GMT https://community.qlik.com/t5/App-Development/Clickable-QlikSense-KPI-s/m-p/1838288#M69310 Correct_Answer 2021-09-22T10:25:28Z