topic Re: Qualify + Hide Prefix in QlikView

Qualify + Hide Prefix

vikasmahajan — Fri, 26 Feb 2016 06:27:42 GMT

Dear All,

I have campaign data with qualify fields with campaign Job Function i have used Set HidePrefix Command to hide selected

fields but when i am selecting campaign Job Function field , This field is visible in selection box . I don't want to show field is selected also i want to use qualify keyword.

Any one can help on this ?

Thanks in adv

Vikas

Re: Qualify + Hide Prefix

jagan — Fri, 26 Feb 2016 06:34:05 GMT

Hi,

It is not possible, you have to rename like below

QUALIFY *;

UNQUALIFY %CampaignId;

Campaign:

LOAD %CampaignCreatedById,

%CampaignId,

%CampaignJobFunction,

%CampaignOwnerId,

%CampaignQTCompany,

[Campaign Annual Revenue Range],

[Campaign Audience],

[Campaign Count],

[Campaign Created Date],

[Campaign Data Source Category],

[Campaign End Date],

[Campaign End Date New],

[Campaign Event Date],

[Campaign Event End Date],

[Campaign Event Start Date],

[Campaign Group Employee Range],

[Campaign Id],

[Campaign Incentive],

[Campaign Line of Business],

[Campaign Objective],

[Campaign Publishable Name],

[Campaign Sector],

[Campaign Start Date],

[Campaign Start Date New],

[Campaign Status],

[Campaign Sub Type],

[Campaign Type],

Month,

Quarter,

Year

FROM

C:\Martin\Campaign.xls

(biff, embedded labels, table is Sheet1$);

RENAME FIELD Campaign.%CampaignJobFunction to %CampaignJobFunction;

UNQUALIFY %CampaignId, %CampaignJobFunction;

Hope this helps you.

Regards,

jagan.

Re: Qualify + Hide Prefix

vikasmahajan — Fri, 26 Feb 2016 06:37:10 GMT

Thanks Jagan I tried using rename field it's working already but i have 30 tables in my data modeling

and I don't want to rename %CampaignJobFunction field will it still possible to hide field in selection box ?

Thanks/

Vikas

Re: Qualify + Hide Prefix

tresB — Fri, 26 Feb 2016 06:49:23 GMT

Another way could be using Tag , like:

Tag Field Campaign.%CampaignJobFunction with '$Hidden';

Re: Qualify + Hide Prefix

vikasmahajan — Fri, 26 Feb 2016 06:51:13 GMT

Thanks Tresesco i will get back you.

Re: Qualify + Hide Prefix

vikasmahajan — Fri, 26 Feb 2016 07:00:45 GMT

First Reply workd !! Tresesco

Thanks

Rename field NonPrdBkp.UpdateStatus to %NonPrdBkp.%UpdateStatus;