topic Conditional Show Issue - Straight Tables in QlikView

Conditional Show Issue - Straight Tables

wonkymeister — Mon, 24 Jun 2013 10:02:35 GMT

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 4^th 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.

Re: Conditional Show Issue - Straight Tables

Gysbert_Wassenaar — Mon, 24 Jun 2013 10:34:13 GMT

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.

Re: Conditional Show Issue - Straight Tables

luciancotea — Mon, 24 Jun 2013 10:43:11 GMT

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)

Re: Conditional Show Issue - Straight Tables

wonkymeister — Mon, 24 Jun 2013 10:48:26 GMT

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

Sorry and thanks fellas.

Monday morning idiocy, more caffeine required