https://community.qlik.com/t5/App-Development/Top-10-Spends-set-expression-is-giving-duplicate-dimenssion/m-p/1824381#M67685 <DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>Hi All,</P><P>&nbsp;</P><P>I need to get Top 10 Spends in a Table. I wrote below expression for measure but is giving duplicate dimension row value.</P><P>PRBS. Ibm is getting 3 times and my count also increase to 12 .</P><P>sum({&lt;SUPPLIER={"=Rank(sum({&lt;TIMEPERIOD={'Q1-2021'}&gt;}[SPEND, USD]),4,0)&lt;=10"},TIMEPERIOD={'Q1-2021'}&gt;}[SPEND, USD])</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HarishM07_2-1627233131006.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59124i92EFC263B2131E0B/image-size/medium?v=v2&amp;px=400" role="button" title="HarishM07_2-1627233131006.png" alt="HarishM07_2-1627233131006.png" /></span></P><P>&nbsp;</P> Sun, 25 Jul 2021 17:12:47 GMT MEDHA07 2021-07-25T17:12:47Z https://community.qlik.com/t5/App-Development/Top-10-Spends-set-expression-is-giving-duplicate-dimenssion/m-p/1824381#M67685 <DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>Hi All,</P><P>&nbsp;</P><P>I need to get Top 10 Spends in a Table. I wrote below expression for measure but is giving duplicate dimension row value.</P><P>PRBS. Ibm is getting 3 times and my count also increase to 12 .</P><P>sum({&lt;SUPPLIER={"=Rank(sum({&lt;TIMEPERIOD={'Q1-2021'}&gt;}[SPEND, USD]),4,0)&lt;=10"},TIMEPERIOD={'Q1-2021'}&gt;}[SPEND, USD])</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HarishM07_2-1627233131006.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59124i92EFC263B2131E0B/image-size/medium?v=v2&amp;px=400" role="button" title="HarishM07_2-1627233131006.png" alt="HarishM07_2-1627233131006.png" /></span></P><P>&nbsp;</P> Sun, 25 Jul 2021 17:12:47 GMT https://community.qlik.com/t5/App-Development/Top-10-Spends-set-expression-is-giving-duplicate-dimenssion/m-p/1824381#M67685 MEDHA07 2021-07-25T17:12:47Z https://community.qlik.com/t5/App-Development/Top-10-Spends-set-expression-is-giving-duplicate-dimenssion/m-p/1824390#M67688 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/68594">@MEDHA07</a>&nbsp; can you share sample data with expected output?</P> Sun, 25 Jul 2021 22:38:42 GMT https://community.qlik.com/t5/App-Development/Top-10-Spends-set-expression-is-giving-duplicate-dimenssion/m-p/1824390#M67688 Kushal_Chawda 2021-07-25T22:38:42Z