topic Top 5 Problems in QlikView https://community.qlik.com/t5/QlikView/Top-5-Problems/m-p/315418#M116396 <HTML><HEAD></HEAD><BODY><P>Hello, I' ve created a table with many values and I tried to get the top 5. </P><P>I've attached my example. With others examples works but this one not.</P><P>Thanks</P></BODY></HTML> Sat, 28 Jan 2012 23:37:03 GMT pgalvezt 2012-01-28T23:37:03Z Top 5 Problems https://community.qlik.com/t5/QlikView/Top-5-Problems/m-p/315418#M116396 <HTML><HEAD></HEAD><BODY><P>Hello, I' ve created a table with many values and I tried to get the top 5. </P><P>I've attached my example. With others examples works but this one not.</P><P>Thanks</P></BODY></HTML> Sat, 28 Jan 2012 23:37:03 GMT https://community.qlik.com/t5/QlikView/Top-5-Problems/m-p/315418#M116396 pgalvezt 2012-01-28T23:37:03Z Re: Top 5 Problems https://community.qlik.com/t5/QlikView/Top-5-Problems/m-p/315419#M116397 <HTML><HEAD></HEAD><BODY><P>Not really sure what you want to achieve, but you get the TOP5 correctly flagged if you read your Amount in as Money data type, not just as text string, i.e. use this as Money format and first line in your load</P><P></P><P>SET MoneyFormat='$ #.##0,00;($#.##0,00)';</P><P></P><P>LOAD&nbsp; PERSON, DOC, [BB ID], [BB NAME], Money#(Amount) as Amount, AN, AR, [DAY 1], [DAY 2], [DAY 3], RDT&nbsp; INLINE [</P><P>...</P><P>];</P></BODY></HTML> Sun, 29 Jan 2012 00:31:47 GMT https://community.qlik.com/t5/QlikView/Top-5-Problems/m-p/315419#M116397 swuehl 2012-01-29T00:31:47Z