topic Re: Current selections without variables in QlikView

Current selections without variables

Thu, 05 Mar 2015 13:48:36 GMT

Hello.

I want that the current selections object show only fields, and won't show the variables.

How can i do that?

Thank you!

Re: Current selections without variables

sunny_talwar — Thu, 05 Mar 2015 13:52:37 GMT

I don't think that current selection box show variables by default.

Best,

Re: Current selections without variables

giakoum — Thu, 05 Mar 2015 13:54:48 GMT

Sunindia is right.

And you can use hideprefix to hide fields from the current selections box

Re: Current selections without variables

sunny_talwar — Thu, 05 Mar 2015 13:56:39 GMT

Thanks giakoum for confirming it. For a second I was puzzled if the current selection box ever showed variables also.

Best,

Re: Current selections without variables

Thu, 05 Mar 2015 13:57:23 GMT

I see that now, thank you.

how can i hide fields i don't need?

Re: Current selections without variables

giakoum — Thu, 05 Mar 2015 14:03:57 GMT

SET Hideprefix = '%';

not let

Re: Current selections without variables

sunny_talwar — Thu, 05 Mar 2015 14:04:21 GMT

Within your script right this:

SET HidePrefix = %;

and then rename all the fields you don't want to show up on current selection box to have % in front of them:

City as %City

HTH

Best,

Re: Current selections without variables

sunny_talwar — Thu, 05 Mar 2015 14:04:56 GMT

Hahahaha, ya you are right, just figured it out.

Re: Current selections without variables

Thu, 05 Mar 2015 14:32:39 GMT

Thank you both!

Re: Current selections without variables

rwunderlich — Thu, 05 Mar 2015 16:28:54 GMT

You can also tag any field with $hidden in the script.

TAG FIELD MyField WITH '$hidden';'

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Current selections without variables

raynac — Tue, 24 Mar 2015 14:56:35 GMT

I have been wanting to hide some selections from the Current Selections box for ages...and didn't think it could be done.

Thank you so much!

Re: Current selections without variables

sunny_talwar — Tue, 24 Mar 2015 15:00:43 GMT

And now you know its possible.

Best,

Sunny

Re: Current selections without variables

raynac — Tue, 24 Mar 2015 15:09:38 GMT

Yes! And I implemented it right away just to test it out...worked like a charm. I learn so many great things from this community.