topic Re: Straight table dimension in QlikView https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866610#M1017496 <HTML><HEAD></HEAD><BODY><P>Hi Priya,</P><P></P><P>You can change that in Number tab.</P><P></P><P>Regards,</P><P></P><P>Faisal</P></BODY></HTML> Tue, 07 Apr 2015 10:07:55 GMT 2015-04-07T10:07:55Z Straight table dimension https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866609#M1017495 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have added one column as dimension in straing table.</P><P>Now I want that in number format when I export to excel.</P><P></P><P>I have changed that in Doc properties-Number, its fine in table box. But when I add as dimension in straight table then its changing it to text when I export.</P><P>I want only 2 decimal after " . ".</P><P></P><P></P><P><BR /> </P></BODY></HTML> Tue, 07 Apr 2015 10:03:45 GMT https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866609#M1017495 priyarane 2015-04-07T10:03:45Z Re: Straight table dimension https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866610#M1017496 <HTML><HEAD></HEAD><BODY><P>Hi Priya,</P><P></P><P>You can change that in Number tab.</P><P></P><P>Regards,</P><P></P><P>Faisal</P></BODY></HTML> Tue, 07 Apr 2015 10:07:55 GMT https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866610#M1017496 2015-04-07T10:07:55Z Re: Straight table dimension https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866611#M1017497 <HTML><HEAD></HEAD><BODY><P>Hi Faisal,</P><P></P><P>It is Dimension, so Its not in number tab.</P></BODY></HTML> Tue, 07 Apr 2015 10:11:11 GMT https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866611#M1017497 priyarane 2015-04-07T10:11:11Z Re: Straight table dimension https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866612#M1017498 <HTML><HEAD></HEAD><BODY><P>Hi Priya,</P><P></P><P>Go to Excel Number format option. Try changing it from General to Number.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards,</SPAN></P><P>Nishant</P></BODY></HTML> Tue, 07 Apr 2015 10:17:03 GMT https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866612#M1017498 Anonymous 2015-04-07T10:17:03Z Re: Straight table dimension https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866613#M1017499 <HTML><HEAD></HEAD><BODY><P>The Number tab is valid only for expression.</P><P></P><P>Add a Calculated Dimension like this:</P><P> </P><P><SPAN style="color: #0000ff; font-size: 10pt;">Num</SPAN><SPAN style="font-size: 10pt;">( </SPAN><SPAN style="color: #800000; font-size: 10pt;">[your field]</SPAN><SPAN style="font-size: 10pt;">,'#.##0,00') </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">on export in excel work for me</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Bye</SPAN></P><P></P></BODY></HTML> Tue, 07 Apr 2015 10:17:08 GMT https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866613#M1017499 2015-04-07T10:17:08Z Re: Straight table dimension https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866614#M1017500 <HTML><HEAD></HEAD><BODY><P>Then</P><P></P><P>edit the dimension and give the following expression</P><P></P><P>=Num(dimension,'#.00')</P><P></P><P></P><P>regards,</P><P></P><P>Faisal</P></BODY></HTML> Tue, 07 Apr 2015 10:21:12 GMT https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866614#M1017500 2015-04-07T10:21:12Z Re: Straight table dimension https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866615#M1017501 <HTML><HEAD></HEAD><BODY><P>still its changing to Text format after exporting to excel.</P></BODY></HTML> Tue, 07 Apr 2015 10:29:03 GMT https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866615#M1017501 priyarane 2015-04-07T10:29:03Z Re: Straight table dimension https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866616#M1017502 <HTML><HEAD></HEAD><BODY><P>still its changing to Text format after exporting to excel.</P></BODY></HTML> Tue, 07 Apr 2015 10:29:58 GMT https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866616#M1017502 priyarane 2015-04-07T10:29:58Z Re: Straight table dimension https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866617#M1017503 <HTML><HEAD></HEAD><BODY><P>Follow this instructions and chose which one you like it.</P><P></P><P>Hope I helped you</P></BODY></HTML> Tue, 07 Apr 2015 11:29:27 GMT https://community.qlik.com/t5/QlikView/Straight-table-dimension/m-p/866617#M1017503 2015-04-07T11:29:27Z