Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
kotoole13
Contributor
Contributor

Hide Columns Drill Down/Show Column IF

Hello,

I'm wondering how I can display the column "Detail Status" only when drilling down?  I'm guessing it has something to do with the "show column if" under the "Detail Status" column.  Right now I have a drill down that goes from "Trans No" to "Part Number  (Sales Order)", and I have taken some screen shots on how I would like it to look before and after drilling down.  However I cannot figure out how to not display the "Detail Status" column at the highest level of the drill down ("Tran. No")

Any help would be appreciated,

 

Kevin

 

 

 

kotoole13_0-1586901135591.png

 

kotoole13_1-1586901207261.png

 

Labels (1)
3 Replies
lironbaram
Partner - Master III
Partner - Master III

Hi

in the Detail status show condition use this 

if(GetObjectDimension(0)='Tran. No',0,1)

please make sure to put the actual field name and not the label 

kotoole13
Contributor
Contributor
Author

Hello Lironbaram,

I tried what you said (see screen shot below), but the "detail status"still shows up as column on the highest level of the drill down?  Any other thoughts??

kotoole13_0-1586984885149.png

 

Thanks again,

 

Kevin

 

lironbaram
Partner - Master III
Partner - Master III

hi 

yes you need to use the expression i sent you , 

you need only to specified the dimension name , not to call the dimension