topic Selection in QlikView

Selection

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

HI ALl,

Hi All ,

I have a QVW file attached ..

I have a filter which i have reneamed as Team..

And in current selection it is displaying the Actaully Name from the script as "FinanaceTeam"

I want it to display the same field name what i have renamed it for the filter as Team..

Can someone please help me witrh this

Thannks in advance

Re: Selection

pradosh_thakur — Tue, 10 Oct 2017 06:15:26 GMT

As per my knowledge it is impossible to do this. You can try out any of the ideas below.

Current Selection Alternatives

regards

Pradosh

Re: Selection

techvarun — Tue, 10 Oct 2017 06:46:22 GMT

You cannot change it. The best solution is load a duplicate field with desired name in the load script.

Re: Selection

smilingjohn — Tue, 10 Oct 2017 06:56:43 GMT

HI Varun ,

I cannot do that , becuase in real application there are many fields with the same name , to avoid linking i have to rename them ,,,

Just wanted to know with one filed as a sample data

Need this solution ...

Re: Selection

pradosh_thakur — Tue, 10 Oct 2017 07:30:04 GMT

Try this workaround

LOAD Team as FinanceTeam,

ID,

loc

FROM

(ooxml, embedded labels, table is Iper);

load distinct FinanceTeam as [Team ]

, FinanceTeam

resident a;

use [Team ] note : it contains an extra space and will not be a key neither will create a link up as filter it will filter the finance team associated with it.

in the current selection it will show up as team with a space but not recognizable. I would have done it in your QVW but it wont reload without the excel.

regards

Pradosh