Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

field?


i have field like

sales contains data

sales:

100

200

300

here i want add before the data _  means like

sales:

_100

_200

_300

  how?

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: field?

Hi in the script , create a new field

load *,

'_'&sales as SalesNew

from....

good luck

Fernando

View solution in original post

5 Replies
Highlighted
Not applicable

Re: field?

You want to concat a '_' in front of every sales value?

Highlighted
Partner
Partner

Re: field?

Hi in the script , create a new field

load *,

'_'&sales as SalesNew

from....

good luck

Fernando

View solution in original post

Highlighted
Not applicable

Re: field?

Load *

'_' & sales as FinalResult

From table

Highlighted
Contributor II
Contributor II

Re: field?

If i understand rightly... in script you can write:

.....................

'_' & 'sales' als newSalesField,,,,,

........................................

regards

Gustavo

Highlighted
Master
Master

Re: field?

Hi Manoj,

Yes try:

In Script:

Load

' - '& sales as sales1

From TableName

Regards

Neetha