Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

crosstable : prices are converted in date format?

Hi,

I don't know why but when I make a crosstable it automatically recognizes my price field as a date

wrongprices.PNG

so instead of 150 I get a 40213 date value or something.

how can that be fixed?

thanks

2 Replies
perumal_41
Valued Contributor II

Re: crosstable : prices are converted in date format?

Hi,

Upload your sample data excel for checking purpose

Not applicable

Re: crosstable : prices are converted in date format?

i found it.

reformat the whole sheet to general, and fix the date with Date(Num#(date_field)) AS Date afterwards

Community Browser