topic Import users from excel in Qlik NPrinting

Import users from excel

jsobrinho — Thu, 25 Jun 2020 20:05:59 GMT

Hi guys,

I need to import a list of users, filters, and groups from excel, but I have a problem when I try to import the code 0123, this is a numeric value, so I am trying to input this value in Numeric value in excel, but when I import, in Nprniting show just 123.

At this moment, to solve this, I change my field in the data model, the code to TEXT(code) so, I can put this filter in Values column, and not ignore 0, but has another way? It's necessary to change the data type?

the same syntax in Values working, but I changed the data type to string.

Re: Import users from excel

Frank_S — Fri, 14 Jun 2019 20:35:46 GMT

I tested the import and it works fine even with a leading zero (testing on NPrinting April 2019):

Discount={0.06049999864772}

Imported filter in NPrinting console:

My source data in numeric and is interpreted accordingly.

Perhaps your source data is in fact text?

Anyway, hopefully this helps to guide you correctly.

Re: Import users from excel

jsobrinho — Thu, 18 Jul 2019 13:44:45 GMT

Thank you for an answer, but my source data is in fact numeric, and I changed to text.

Re: Import users from excel

Daniel_Jenkins — Fri, 19 Jul 2019 02:28:02 GMT

Hi @jsobrinho ,

I see this as working as intended. The numeric value of 0123 is in fact 123. Of course you can change the display format (in Excel for example)...

...to show leading zero's but the numeric value itself will be 123. I am not sure why you expect it to be otherwise.

HTH - Daniel.