topic Re: crosstable : prices are converted in date format? in QlikView https://community.qlik.com/t5/QlikView/crosstable-prices-are-converted-in-date-format/m-p/381396#M1170085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Upload your sample data excel for checking purpose</P></BODY></HTML> Tue, 28 Aug 2012 09:44:47 GMT perumal_41 2012-08-28T09:44:47Z crosstable : prices are converted in date format? https://community.qlik.com/t5/QlikView/crosstable-prices-are-converted-in-date-format/m-p/381395#M1170084 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I don't know why but when I make a crosstable it automatically recognizes my price field as a date <IMG src="https://community.qlik.com/legacyfs/online/emoticons/angry.png" /></P><P></P><P><IMG __jive_id="20725" class="jive-image-thumbnail jive-image" onclick="" alt="wrongprices.PNG" src="https://community.qlik.com/legacyfs/online/20725_wrongprices.PNG" width="450" /></P><P></P><P>so instead of 150 I get a 40213 date value or something.</P><P></P><P>how can that be fixed?</P><P></P><P>thanks</P></BODY></HTML> Tue, 28 Aug 2012 09:12:10 GMT https://community.qlik.com/t5/QlikView/crosstable-prices-are-converted-in-date-format/m-p/381395#M1170084 2012-08-28T09:12:10Z Re: crosstable : prices are converted in date format? https://community.qlik.com/t5/QlikView/crosstable-prices-are-converted-in-date-format/m-p/381396#M1170085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Upload your sample data excel for checking purpose</P></BODY></HTML> Tue, 28 Aug 2012 09:44:47 GMT https://community.qlik.com/t5/QlikView/crosstable-prices-are-converted-in-date-format/m-p/381396#M1170085 perumal_41 2012-08-28T09:44:47Z Re: crosstable : prices are converted in date format? https://community.qlik.com/t5/QlikView/crosstable-prices-are-converted-in-date-format/m-p/381397#M1170086 <HTML><HEAD></HEAD><BODY><P>i found it.</P><P></P><P>reformat the whole sheet to general, and fix the date with Date(Num#(date_field)) AS Date afterwards</P></BODY></HTML> Tue, 28 Aug 2012 09:47:27 GMT https://community.qlik.com/t5/QlikView/crosstable-prices-are-converted-in-date-format/m-p/381397#M1170086 2012-08-28T09:47:27Z