Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

wonkymeister
Contributor

Conditional Show Issue - Straight Tables

Happy Monday!

I have a straight table with a drill down as a dimension. The Drill down dimension has 4 levels – Faculty, Division, Course and student.

Once the user reaches the 4th level by drilling down through the dimension to Student, I want to change the table that is displayed (I want to display different columns at the Student level as opposed to the original columns displayed at the Faculty level)

Now obviously if I was using selectors outside of the straight table it would be easy, just using GetSelectedCount etc

But I’m not – nothing outside of the chart is being selected, only the dimension itself from within the table

So my question is, how can I make my table disappear and another appear when the user drills down to the lowest level in the dimension? (i.e. conditional show)

Thanks in advance

Wonky.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Conditional Show Issue - Straight Tables

You should still be able to use getselected count. The drill downgroup constists of fields. By drilling down, you make a selection in the current field in the group and the chart drills down to the next field in the group. If you add listboxes for the fields in the drilldown group you will see that values get selected. So, using the getselectedcount function should work.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
MVP & Luminary
MVP & Luminary

Re: Conditional Show Issue - Straight Tables

You should still be able to use getselected count. The drill downgroup constists of fields. By drilling down, you make a selection in the current field in the group and the chart drills down to the next field in the group. If you add listboxes for the fields in the drilldown group you will see that values get selected. So, using the getselectedcount function should work.


talk is cheap, supply exceeds demand

View solution in original post

luciancotea
Valued Contributor

Re: Conditional Show Issue - Straight Tables

Use this in conditional show for the Student Detail table: = if( only(Student), 1 , 0)

Use this in conditional show for the All Students table:     = if( only(Student), 0 , 1)

wonkymeister
Contributor

Re: Conditional Show Issue - Straight Tables

Of course it does, i'm being a total idiot

Sorry and thanks fellas.

Monday morning idiocy, more caffeine required