topic Need help on Clickable KPI's in Qlik Sense on Dimension in App Development https://community.qlik.com/t5/App-Development/Need-help-on-Clickable-KPI-s-in-Qlik-Sense-on-Dimension/m-p/1837348#M69205 <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-1632050086534.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/62265iA2D49185A3CFC1F7/image-size/medium?v=v2&amp;px=400" role="button" title="Correct_Answer_0-1632050086534.png" alt="Correct_Answer_0-1632050086534.png" /></span></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> Sun, 19 Sep 2021 11:19:12 GMT Correct_Answer 2021-09-19T11:19:12Z Need help on Clickable KPI's in Qlik Sense on Dimension https://community.qlik.com/t5/App-Development/Need-help-on-Clickable-KPI-s-in-Qlik-Sense-on-Dimension/m-p/1837348#M69205 <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-1632050086534.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/62265iA2D49185A3CFC1F7/image-size/medium?v=v2&amp;px=400" role="button" title="Correct_Answer_0-1632050086534.png" alt="Correct_Answer_0-1632050086534.png" /></span></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> Sun, 19 Sep 2021 11:19:12 GMT https://community.qlik.com/t5/App-Development/Need-help-on-Clickable-KPI-s-in-Qlik-Sense-on-Dimension/m-p/1837348#M69205 Correct_Answer 2021-09-19T11:19:12Z