Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
Hi DataNibbler
I found a solution for this, convert your excel to csv format then load the data from it, then use isnum() dates will be loaded as string and rest of thing will be loaded as num. this will solve the issue.
Excel will not handle this text and number format efficiently, when you convert it to csv, it define the actual format.
Hope this helps you