topic Re: Display extra column on lowest level of drill-down in App Development

Display extra column on lowest level of drill-down

BenkV — Sat, 16 Nov 2024 06:45:47 GMT

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

Re: Display extra column on lowest level of drill-down

dplr-rn — Thu, 24 Jan 2019 16:57:05 GMT

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

Re: Display extra column on lowest level of drill-down

BenkV — Thu, 24 Jan 2019 17:05:57 GMT

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