Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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