topic Re: Changing Field value in QVW in QlikView

Changing Field value in QVW

johnjustus — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Changing Field value in QVW

sunny_talwar — Tue, 07 Feb 2017 21:57:16 GMT

May be like this:

LOAD If([Report Name] = 'Test-GC/HD', 'Test-GC-HD', [Report Name]) as [Report Name]

Re: Changing Field value in QVW

johnjustus — Tue, 07 Feb 2017 22:04:53 GMT

Thanks. I want to do in the document.

Is it possible to edit the existing field that is returned from the script in the document and apply any relevant function?

Re: Changing Field value in QVW

sunny_talwar — Tue, 07 Feb 2017 22:07:00 GMT

You mean you want to do this on the front end? You sure can.... anywhere you were going to use [Report Name], use the above statement instead

Re: Changing Field value in QVW

johnjustus — Tue, 07 Feb 2017 22:19:57 GMT

Where exactly I need to apply the statement in the UI?

I brought the field to a list box to see if there is a place in the properties that I can change it but I don't find any.

Can you please advice?

Thanks

Re: Changing Field value in QVW

sunny_talwar — Tue, 07 Feb 2017 22:22:31 GMT

Instead of using a field for your list box, use expression

Re: Changing Field value in QVW

vishsaggi — Tue, 07 Feb 2017 22:25:09 GMT

Copy Sunny's expression in your Listbox -> Field dropdown -> scroll to the bottom you can see Expression

then type

= If([Report Name] = 'Test-GC/HD', 'Test-GC-HD', [Report Name])

Re: Changing Field value in QVW

sunny_talwar — Wed, 08 Feb 2017 01:44:12 GMT

What is your field name? Report Name or what?

Re: Changing Field value in QVW

johnjustus — Wed, 08 Feb 2017 13:50:08 GMT

Thanks Everyone.

In the particular list box the value changes but my original "Report Name" still holds the original values.

I am calling this "Report Name" in many places and even in Nprinting and I want the values in "Report Name" field to contain the modified values.

Is it not possible in the UI?

Thanks

Re: Changing Field value in QVW

Anonymous — Wed, 08 Feb 2017 14:18:50 GMT

Hi John,

In that case, Create a Variable with the same name as your field name. Like the one below. Go to,

Settings-->Variable Overview -->Add.

Then Use that variable where ever you want. In the list box, give it as an expression.

Good Luck......

Re: Changing Field value in QVW

vishsaggi — Wed, 08 Feb 2017 14:19:31 GMT

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

Re: Changing Field value in QVW

krishnacbe — Wed, 08 Feb 2017 14:26:40 GMT

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.

Re: Changing Field value in QVW

Anonymous — Thu, 09 Feb 2017 06:12:28 GMT

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.

Re: Changing Field value in QVW

johnjustus — Fri, 10 Feb 2017 22:24:46 GMT

Thanks Everyone.

Crating an variable worked.