topic Re: How to use HidePrefix in an Inline. in QlikView

How to use HidePrefix in an Inline.

Mon, 17 Sep 2012 17:30:21 GMT

Hi,

I have some Inline table where I want to use HidePrefix in order to hide these feilds from being displayed in current selection box.

Any help will be highly appreciated.

For Eg: here I want to hide feild Alphabet from being displayed as I have always one value selected in this list box.

SET HidePrefix='~';

How_to:

LOAD * Inline [

Alphabet as [~Alphabet],

];

Regards

Sagar Gupta

Re: How to use HidePrefix in an Inline.

Anonymous — Mon, 17 Sep 2012 17:53:55 GMT

Sagar,

This is how it can be done:

SET HidePrefix='~';

How_to:

LOAD * Inline [

~Alphabet,

];

Regards,

Michael

Re: How to use HidePrefix in an Inline.

Mon, 17 Sep 2012 18:10:53 GMT

Thanks a lot

I was trying using alias name and it was not working.

Regards

Sagar Gupta

Re: How to use HidePrefix in an Inline.

Tue, 11 Dec 2012 10:34:11 GMT

Hi Michael/Sagar,

I have same kind of issue, am using Set HidePrefix like below and i have drill down group(added number dimension in drill exp like

=If(NUMBER=1,GROUP1, If(NUMBER=2, If(Match(REGIONS, ABC,DEF, GHI,JKL), REGIONS)))

) in my app so if we use the drill down group in any chart then Number is getiing hiden from Current Selection Box but real problem drill down is not worlking correctly. So how can we implement this.

Set HidePrefix='~';

NUMBER:
LOAD* INLINE[

~NUMBER

];