topic Re: Set hideprefix ='%'; not working in QlikView

Set hideprefix ='%'; not working

robert99 — Tue, 18 Mar 2014 09:48:55 GMT

It worked fine on my personal edition at home (on a small example)

But at work it does not work.

It's not a big issue. I just wanted to exclude a selection from the current selection box

But any suggestion as to the reason why it might not work at work would be appreciated

I have used both a % and ^ at work and neither worked

Set hideprefix ='%';

Customer,
Customer AS %C2,

Thanks

Re: Set hideprefix ='%'; not working

MK_QSL — Tue, 18 Mar 2014 09:52:10 GMT

Please check that Show System Fields should untick..

Show

Re: Set hideprefix ='%'; not working

its_anandrjs — Tue, 18 Mar 2014 10:03:15 GMT

Hi,

Your code for syntax is correct please check by click on check box for Show System Fields.

Thanks & Regards

Re: Set hideprefix ='%'; not working

robert99 — Tue, 18 Mar 2014 10:29:23 GMT

Thanks Manish

I'm currently at home so will try at work as soon as I arrive (ie to see if this is a system field or not)

But I have noticed that if I have two hideprefix (es) only the 2nd one works

Its possible this might also be the problem. Another person worked on the work file so he may have added a Set hideprefix somewhere

But I will try this as soon as I get to work

Re: Set hideprefix ='%'; not working

Miguel_Angel_Baeyens — Tue, 18 Mar 2014 10:36:15 GMT

Hi,

That is correct. As any other variable set in the load script, the last definition is the one is kept. Note that QlikView script is run from the first line to the last, and if you have the same variable assignment in different lines of the script, only the last value will be stored.

Regards,

Miguel

Re: Set hideprefix ='%'; not working

robert99 — Tue, 18 Mar 2014 10:44:27 GMT

Thanks

I can't think of any reason why the consultant should have added another set hideprefix but he may have

Its one of these things that isn't really important but it bugs me that I could not get it to work.

Re: Set hideprefix ='%'; not working

MK_QSL — Tue, 18 Mar 2014 10:47:48 GMT

If you have two hideprefix like below, the second will work..

In below case, You can see %C2 as normal field and _C2 as System field as it will be hidden.

Hope this helps..

Set hideprefix ='%';

Set hideprefix ='_';

Load

Customer as %C2,

Customer as _C2 Inline

[

Customer, Sales

A, 100

B, 1000

];

Re: Set hideprefix ='%'; not working

robert99 — Tue, 18 Mar 2014 21:21:38 GMT

The consultant had added a let hideprefix = '_'

I removed this and it worked