topic Re: Update column names in expression in QlikView

Update column names in expression

Anonymous — Wed, 22 Oct 2014 08:04:19 GMT

Hello Experts,

For user convenience I am chaning Column name in script.

Is there anyway it will automatically replace old to new one in dimension and expressions of charts.

Thanks

Kiran

Re: Update column names in expression

Gysbert_Wassenaar — Wed, 22 Oct 2014 08:21:38 GMT

Changing field names will automatically be updated after a reload in charts and (most) expressions, but not in variables.

Re: Update column names in expression

anbu1984 — Wed, 22 Oct 2014 08:22:36 GMT

If you change the name in script and reload, then the changed name will automatically reflect in dimension and expression

Re: Update column names in expression

rustyfishbones — Wed, 22 Oct 2014 08:23:40 GMT

It should do this automatically once you change in the Script and Reload the Data

Re: Update column names in expression

Anonymous — Wed, 22 Oct 2014 09:11:16 GMT

It's not happing in my end. I am using it in set expression.

I am working QV 11 SR 6 v3ersion.

Is this req, any setting?

Re: Update column names in expression

Anonymous — Wed, 22 Oct 2014 10:22:04 GMT

What I found is that if column name is allready aliase with diffrent name and I am chaning that again,It won't change automatically in chart.

it's only work if you are doing rename 1st time.

Please let me know is there a way to it will reflect all the time

Thaanks & Regards,

Kiran Kokade

Re: Update column names in expression

anbu1984 — Wed, 22 Oct 2014 10:55:42 GMT

It will reflect all the time automatically. Can you post sample qvw and column which you are facing issue

Re: Re: Update column names in expression

Anonymous — Fri, 24 Oct 2014 10:18:01 GMT

Please check attached file.

Re: Re: Update column names in expression

hic — Fri, 24 Oct 2014 11:15:52 GMT

It works on my computer.

First, you need to rename the field back to Sales_Update, so that QlikView "finds" the mapping again. Once this is done, you can rename the field in the script again, and then it works.

What has happened is probably that you renamed and added a field at the same time, and then the field mapping is lost.

HIC

Re: Update column names in expression

Anonymous — Fri, 24 Oct 2014 13:07:55 GMT

Henric Cronström

What I found is if I rename and after that if I remove rename or keep original name as rename.It won't update original name.

For e.g If original name is Sales1st

1.I am update it Sales as Sales_Update and reload it works.

2.Then I again update Sales as Sales and reload it then it won't update Sales_Update to Sales.

I know this is find quiete silly but I just want to understant why it's not working if I remove aliase.

Thanks

Kiran.

Re: Update column names in expression

hic — Fri, 24 Oct 2014 13:19:39 GMT

Because you change both name and load order. "Sales" is already loaded in the first table, whereas Sales_Update is loaded in the second.

HIC

Re: Update column names in expression

Anonymous — Mon, 27 Oct 2014 07:23:07 GMT

Can we say this as limitation?

Thanks

Kiran

Re: Update column names in expression

hic — Mon, 27 Oct 2014 08:08:53 GMT

No, it is rather a question about what is theoretically possible. In this case, there is no way for QlikView to “know” which field is which, without making an analysis of the field values before and after the script run. And this, QlikView doesn't do.

The logic is simple: If you keep the names the same, but change the order, e.g.

A, B, C, D --> A, D, C, B

then it works. And if you keep the order and change one or several field names, e.g.

A, B, C, D --> A, E, C, F

then it also works.

But if you make more complex changes, it doesn't work.

HIC