Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with Set HidePrefix and Drill down group

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

1

2

3

4

];

1 Reply
atafsson
Creator
Creator

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

];

/A