topic Re: Ad-Hoc report Dimensions and expression selection in CurrentSelection box in QlikView

Ad-Hoc report Dimensions and expression selection in CurrentSelection box

thakkarrahul01 — Thu, 10 Dec 2015 15:01:20 GMT

Hello Experts,

While selecting dimensions and expressions used for Ad-Hoc Report straight table selections are appearing in the current selection box, which I don't want to display. I am missing at some step, Can anyone please help.

Please find attached qvw for sample.

swuehl‌ MRKachhiaIMP‌hic‌gwassenaar‌rwunderlich‌

Re: Ad-Hoc report Dimensions and expression selection in CurrentSelection box

Kushal_Chawda — Thu, 10 Dec 2015 17:39:25 GMT

I didn't understand .. can you elaborate

Re: Ad-Hoc report Dimensions and expression selection in CurrentSelection box

swuehl — Thu, 10 Dec 2015 18:16:50 GMT

Use a hide prefix in your script:

SET HidePrefix = '_';

Re: Ad-Hoc report Dimensions and expression selection in CurrentSelection box

thakkarrahul01 — Fri, 11 Dec 2015 08:58:41 GMT

Perfect !! Thank you swuehl!

Re: Ad-Hoc report Dimensions and expression selection in CurrentSelection box

Fri, 11 Dec 2015 14:21:42 GMT

I actually like $hidden tag better, gives you a bit more control but both ways works of course .

tag Fields _Dimension,_Metric,ReportName $hidden;