Changing Field value in QVW

[johnjustus]

Hi,

I have a field called "Report Name" in a qvw and this field has few values.

Out of the few values, one value is Test-GC/HD

I wanted to change the value to Test-GC-HD

How can I go about doing this change and I want the field name to stay as is "Report Name"

Appreciate your help!

Thanks

[vishsaggi]

Did you try mine or Sunny's reply above using an expression in Listbox? What is that you are expecting to see in UI ?

[krishnacbe]

In that case use the expression shared by Sunny, where ever you use the Report Name field.

If there are multiple instances, then move the code to Load statement.

[Anonymous]

If you want to do in the front End, in the above screen shot shared, Use  the variable. use the expression = If([Report Name] = 'Test-GC/HD', 'Test-GC-HD', [Report Name]) and give the variable name as [Report Name], and use the variable as a dimension where ever you want. Please refer my previous post for detailed explanation.

[johnjustus]

Thanks Everyone.

Crating an variable worked.