topic Re: Calculated Dimension and Rank in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Rank/m-p/692829#M250627 <HTML><HEAD></HEAD><BODY><P>I found a solution that works for this case...</P><P></P><P>Instead of using rank I used Market share for ranking the products in Store, Region and National, and the calculated dimension works fine!</P><P></P><P>Thanks any way...</P><P></P><P>Regards,</P><P></P><P>Francisco.</P></BODY></HTML> Tue, 17 Jun 2014 10:50:18 GMT 2014-06-17T10:50:18Z Calculated Dimension and Rank https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Rank/m-p/692828#M250626 <HTML><HEAD></HEAD><BODY><P><EM>Hi,</EM></P><P></P><P>I´m working in a a table chart like this</P><P></P><P>Product StoreSales RegionSales NationalSales</P><P></P><P>I created a calculated dimension to only appear products with NationalSales&gt;0, so no zero (Store, Region, National) Sales appear on the table.</P><P></P><P>This works fine, the problem is when I insert a column with Rank, for example, Product Store Rank, when I do this the calculated dimension is not working anymore and zero National Sales appear on the table.</P><P></P><P>What can I do?</P><P></P><P>Thanks in advance,</P><P></P><P>Francisco</P></BODY></HTML> Tue, 17 Jun 2014 10:10:47 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Rank/m-p/692828#M250626 2014-06-17T10:10:47Z Re: Calculated Dimension and Rank https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Rank/m-p/692829#M250627 <HTML><HEAD></HEAD><BODY><P>I found a solution that works for this case...</P><P></P><P>Instead of using rank I used Market share for ranking the products in Store, Region and National, and the calculated dimension works fine!</P><P></P><P>Thanks any way...</P><P></P><P>Regards,</P><P></P><P>Francisco.</P></BODY></HTML> Tue, 17 Jun 2014 10:50:18 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-and-Rank/m-p/692829#M250627 2014-06-17T10:50:18Z