Display extra column on lowest level of drill-down

[BenkV]

Hello All,

I have a 3-layered drill-down hierarchy; lets call it 'Business Type'->'Operation division'->'Team'

Each Business Type has unique Operational divisions and each Operational division has unique Teams.

I currently have a bar chart displaying this structure, with a table next to it showing three columns. I want to make a fourth column appear only once a Team is selected. Doesn't matter which team.

I have looked all over the community and found nothing which directly solves my problem, so your help would be greatly appreciated! 

- Ben

[dplr-rn · Accepted solution]

If you mean a new column on a straight /pivot table you can do so in latest versions of qlik sense.
there is 'Show column if' option that you can use along with maybe GetSelectedCount(team)>0

[BenkV]

Amazing, thank you for the fast response. Did not realise it would be so simple!