Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
oliveton
Creator
Creator

Particular Format of Number Not Appearing When Loaded into Qlikview Chart

Hello, 

I have a set of data that I have loaded into a Qlikview straight table. 

All of the numbers and the data that go with them appear in the chart just fine. 

Except one group of numbers (all formatted about the same) is missing from the chart. 

Below is a screen shot of some of these numbers. Would anyone be able to tell whether these need to be loaded in some special format ? 

I have other numbers in the file that have numbers and letters like the ones below and they load just fine.

I have done nothing special in the load script, but I did try formatting them as numbers i.e. num(123),  and that did not make a difference. 

Really appreciate any suggestions! 

oliveton_0-1618856175214.png

 

 

 

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

This are alpha-numeric values respectively strings. If you now applies num() on them it will just return NULL. This means you need at first to remove the string-chars, maybe just with:

keepchar(Material, '0123456789') as Material

- Marcus