topic Re: How to load as is values from data into qlikview in QlikView

How to load as is values from data into qlikview

Mon, 14 Aug 2017 12:56:05 GMT

Hello Qlikers,

When I am loading data into qlikview the value from the database is not reflected as is in the list box but changes in list box.

Eg. I have the value 19 and 019 in data but after loading the data in qlikview only 19 is available.

Attached is the excel and Qvw file.

Any help is much appreciated and thanks in advance

Regards,

Pratik

Re: How to load as is values from data into qlikview

Anil_Babu_Samineni — Mon, 14 Aug 2017 13:20:03 GMT

Does Text(FieldName) as FieldName is not working for you?

Re: How to load as is values from data into qlikview

Mon, 14 Aug 2017 13:31:40 GMT

Hi Anil,

Neither Text() nor Num() is giving expected output.

Regards,

Pratik

Re: How to load as is values from data into qlikview

petter — Mon, 14 Aug 2017 13:43:03 GMT

This is how QlikView works actually.

Let me explain. When QlikView reads data from any source it will interpret the values and if they can be parsed into numbers they will become numbers.

Both 19 and 019 will be parsed into the number 19. But along with the interpretation it also remembers the format of the numbers so if 19 comes first that format will be shared with other numbers later that is being interpreted into the number 19.

All values in QlikView can be dual - meaning that they have one and only one text (presentation) representation associated with one specific value.

If you create a mini QlikView application like this with a Table Box to show the results and an INLINE table to give some various number you can play with you will see my point and understand how QlikView works:

Re: How to load as is values from data into qlikview

Anil_Babu_Samineni — Mon, 14 Aug 2017 14:17:00 GMT

Good explanation, Do we have work around to over come. Because, When i am loading same file into Qlikview it's not getting real values. I used Text() also no use AON. Will you explain or show the same. And, If i do same format in Excel (Assume, My data source) it's working using Text. But, If it is in General Format from custom it's not working.

Please free to explain when you have time

Re: How to load as is values from data into qlikview

Anil_Babu_Samineni — Mon, 14 Aug 2017 14:18:06 GMT

Num() should work, But it elapse to more digits Num(FieldName,'000000') as FieldName

Re: How to load as is values from data into qlikview

Mon, 14 Aug 2017 17:00:53 GMT

Thanks for the explanation. But do we have any way out by which we can stop qlikview from interpreting and just using the input as-is. The requirement is such that there is a field Invoice Number in Oracle database. The value in this field is Invoice number which is provided by vendor which is not consistent. It can be alphanumeric, comma separated, can have a decimal in it, can have preceding zeroes.. So need to distinguish each value from other as the there is invoice amount associated which is getting clubbed together as of now..

Any solution to load values in as - is format from database?

Re: How to load as is values from data into qlikview

petter — Tue, 15 Aug 2017 07:54:05 GMT

If you use the Text() function and wrap the column from your source in that function the corresponding field in QlikView will be an uninterpreted text.

Simply;

Text( invoice_number ) AS invoice_number

Do you need to split the text field into various subfields too? Then the SubField() function can be used.