topic Displaying Amount format in M￥ in QlikView https://community.qlik.com/t5/QlikView/Displaying-Amount-format-in-M/m-p/233131#M84675 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a very unique requirement for a Japanese Customer.</P><P>Please find below is my requirement.</P><P>Normal Display:</P><P>2008 2009 2010</P><P>P1 ?750,000,000 ?852,006,452 ?250,005,698</P><P>P2 ?150,000 ?250,000,000 ?98,000,000</P><P>P3 ?25,000 ?259,000,000 ?108,000,000</P><P></P><P>Now I want the above display in the Pivot table as follows:</P><P>2008 2009 2010</P><P>P1 M?750 M?852 M?250</P><P>P2 M?1.5 M?250 M?98</P><P>P3 T?25 M?259 M?108</P><P>M? -- To Display Million Data</P><P>T? -- To Display Thousand Data</P><P>B? -- To Display Billion Data</P><P>Is this possible in Qlikview?</P><P>Please help me...</P><P></P></BODY></HTML> Tue, 01 Mar 2011 04:29:13 GMT 2011-03-01T04:29:13Z Displaying Amount format in M￥ https://community.qlik.com/t5/QlikView/Displaying-Amount-format-in-M/m-p/233131#M84675 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a very unique requirement for a Japanese Customer.</P><P>Please find below is my requirement.</P><P>Normal Display:</P><P>2008 2009 2010</P><P>P1 ?750,000,000 ?852,006,452 ?250,005,698</P><P>P2 ?150,000 ?250,000,000 ?98,000,000</P><P>P3 ?25,000 ?259,000,000 ?108,000,000</P><P></P><P>Now I want the above display in the Pivot table as follows:</P><P>2008 2009 2010</P><P>P1 M?750 M?852 M?250</P><P>P2 M?1.5 M?250 M?98</P><P>P3 T?25 M?259 M?108</P><P>M? -- To Display Million Data</P><P>T? -- To Display Thousand Data</P><P>B? -- To Display Billion Data</P><P>Is this possible in Qlikview?</P><P>Please help me...</P><P></P></BODY></HTML> Tue, 01 Mar 2011 04:29:13 GMT https://community.qlik.com/t5/QlikView/Displaying-Amount-format-in-M/m-p/233131#M84675 2011-03-01T04:29:13Z