Issue with Set HidePrefix and Drill down group

Tue, 11 Dec 2012 10:41:35 GMT

Hello,,

I have a problem with Set HidePrefix with drill down group, am using Set HidePrefix like below and i have a drill down group(added number dimension in drill exp like =If(NUMBER=1,GROUP1, If(NUMBER=2, If(Match(REGIONS, AMC,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 by using below script but real problem is drill down is not worlking correctly. So how can we implement this.

Set HidePrefix='~';

NUMBER:
LOAD* INLINE[

~NUMBER

];

Re: Issue with Set HidePrefix and Drill down group

atafsson — Tue, 11 Dec 2012 12:23:34 GMT

Hi Anil, what if you has both fields aviable!?

In the drill down group you use NUMBER ant in listboxes you use ~NUMBER.

The only way to choose NUMBER is through the drill down group...

LOAD* INLINE[

~NUMBER, NUMBER

1, 1

2, 2

3, 3

4, 4

];

topic Issue with Set HidePrefix and Drill down group in QlikView

Issue with Set HidePrefix and Drill down group

Re: Issue with Set HidePrefix and Drill down group