Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Returned Data Formatting

Hello,

I loaded the data repository, in this case a Nomenclature Section, which appear to disrupt Qlik Sense restitution.

following example:

I support two different code section:

- An Article '000002' code

- Another item code '0000002'.

=> In a PivotTable, the return is then made in the same article code '0000002'

It seems that by default Qlik performs a kind of "lpad" values. Is it possible to avoid this?

Thank you for your help.

Regards,

Silvan



Note: Title translated to English by Community Moderator as a courtesy.

1 Reply
swuehl
MVP
MVP

That's because QS is taking these values as number, 2, and Qlik can only store a single text representation per number value, the first one in load order.

If these two values need to be kept as distinct values, try to use text() function when loading the values in:

LOAD

     Text(Article) as Article,

     ...