Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
vidyasagar159
Contributor II

Data Formatting Issue

Hi,

Can someone please help me the value alignment from the below screenshot. I want to start the value "457" from the left.

Options I tried in ScriptEditor:

TRIM

IF Condition

Replace

Formatting Issue.PNG

Thanks,

-Vidya

Tags (1)
1 Solution

Accepted Solutions
giovanneb
Contributor II

Re: Data Formatting Issue

Hi, try this

text(PLANTYPE) as PLANTYPE


Best reguards

View solution in original post

2 Replies
giovanneb
Contributor II

Re: Data Formatting Issue

Hi, try this

text(PLANTYPE) as PLANTYPE


Best reguards

View solution in original post

Partner
Partner

Re: Data Formatting Issue

Hi,

Use the text() statement to transform your number into text.

Do something like:

Load

     text(PLANTYPE) as PLANTYPE

From [Whatever];

Felipe.