Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
ivanville18
Contributor
Contributor

How to use replace in a expression

Hello, please help me! I have this expression: 

=Count({<Message={'Activated sheet Document\SH01','Activated sheet Document\SH02','Activated sheet Document\SH09','Activated sheet Document\SH10','Activated sheet Document\SH11','Activated sheet Document\SH12','Activated sheet SH01','Activated sheet SH02','Activated sheet SH09','Activated sheet SH10','Activated sheet SH11','Activated sheet SH12'}>}Message)

 

I need to replace the text in the table : 'Activated sheet Document\SH01' and 'Activated sheet SH01' for the text 'Inicio', and the same for the other values for example: 

 

Activated sheet Document\SH02' and Activated sheet SH02 for the the text 'Billings'

 

Do  I need to modify the expression or I need to do in the script? 

 

Thanks!

Labels (1)
2 Replies
anushree1
Specialist II
Specialist II

Either Way it should work , If you are changing the Script then the column names will be renamed;

If on Expression it will be the correction done to match the applicable values.

ivanville18
Contributor
Contributor
Author

Thank you so much, you know how to modify the expression?