Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

INPUTFIELD: Date changes to Number via Chrome

Hello,

Has anybody seen\have an answer to this issue?

I am looking to use:

INPUTFIELD [Start Date];

To allow a field to be used for input\change the value.

On my local client everything is fine and the with something like:

     Start Date     04/01/2017

When I view the same field via Chrome (I have not tried other web browsers) I get a number, something like:

     Start Date     42740

As I am just testing out something the load script is fairly basic, with the data relating to this being:

INPUTFIELD [Start Date];

INPUTFIELD [Maturity Date];

Trade:

LOAD Text([Trade Reference]) AS [Trade Reference],

  Product,

  Book,

  Client,

  DATE([Start Date]) AS [Start Date],

  DATE([Maturity Date]) AS [Maturity Date],

  [Volume USD],

  [Mark Up USD];

LOAD * INLINE [

  Trade Reference, Product, Book, Client, Start Date, Maturity Date, Volume USD, Mark Up USD

  123456, FX Forward USD EUR, FX Spot G10, Test Client, 01/01/2017, 02/02/2017, "10,000,000", 3000

  123457, FX Forward USD GBP, FX Spot G10, Test Client, 02/01/2017, 02/06/2017, "2,000,000", 0

  123458, FX Forward USD JPY, FX Spot G10, Test Client, 03/01/2017, 04/04/2017, "30,000,000,000", 0

  123459, FX Forward USD CHF, FX Spot G10, Test Client, 04/01/2017, 01/09/2017, "50,000,000", 1500

];


Has anybody seen this before, or is it me??? Any suggestions welcomed,


Thanks

Labels (1)
0 Replies