Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

How To change Row Value while creating Straight table

Hi Community,

How I can replace

* as CurrentYear

? as PreviousYear

# as PreviousYear

DataRevenue
*ACTUAL2
?ACTUAL3
Revenue#4

Table Should be like this

DataRevenue
2017ACTUAL2
2016ACTUAL3
REVENUE20164
1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Satish,

may be like (in Script)

LOAD Field,

Replace(Replace(Replace(Data,'*',Year(Today())),'?',Year(Today())-1),'#',Year(Today())-1)  as Data

From Table;

Or You can use Expression directly in straight table.

Regards,

Antonio

View solution in original post

3 Replies
antoniotiman
Master III
Master III

Hi Satish,

may be like (in Script)

LOAD Field,

Replace(Replace(Replace(Data,'*',Year(Today())),'?',Year(Today())-1),'#',Year(Today())-1)  as Data

From Table;

Or You can use Expression directly in straight table.

Regards,

Antonio

View solution in original post

Anil_Babu_Samineni

May be this?

=Replace(Replace(Replace(Data,'*',Year(Today())),'?',Year(Today())-1),'#',Year(Today())-1)

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anil_Babu_Samineni

But not sure, How many field values you need to change?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)