Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change value if matching condition

All,

I would like to clean up the data directly in QLikView.

For instance, I would like to merge the data who have apparently same billing account, but expressed a different way,

ex. billing account has the values Company LTD and Company LIMITED, I would like to rename billing account to Company LTD when it is Company LIMITED.

is it possible to achieve so ?

where should script be done:

- in Expression tab

- in the Edit Script

?

could you propose a script for this simple case? more precisely, Sales Accounts should match exactly, and Billing Account should be * LTD or * LIMITED.

I am working with pivot table

Thanks

10 Replies
Not applicable

could you say more precise what you mean with 'fields of the table' ?

i would like to have then

CleanUpMap:

mapping load * inline [

[Billing Account]

'LTD', 'LIMITED'

];

but this is not compiling.

Thanks