Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV does not read num posts from Excel

I read an Excel in this format. The first field have text strings on some rows and all numbers in others.

12515305616Q85360     1      10.04.08      2015-02-11      10:53:19
12514257614185300      1      08.04.08      2015-02-11      09:27:09

The fields that contain a letter is read but not the fields that are all numbers.

If I use Num() the number fields show up but not the letter fields. Text() makes no difference.

Tried to add a '¤' in front of the string and read the source resident. Same result.

Probably some easy fix, right?

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

The text() function should work. But try using the evaluate() function. If that doesn't give you the results you want could you post an excel file with some example data?


talk is cheap, supply exceeds demand