Enable Conditional for Dimensions

[#1]

Hi, I just started using QlikView  and am trying to use the Count(DISTINCT(dimension))=1 so that a dimension will only be visible when a single value from a dimension a level above is selected. My dimensions are:

Period

Division

BL

Desk

I am using the expression Count(DISTINCT(dimension))=1 as the condition and this works well for BL

However, when I select a distinct business line the desks are not displayed.

It's not until I select a single period that the desk is displayed.

How can I get the desk to display regardless of the number of periods (creationmonthyear lable) selected?

Thanks,

Brian

[#2]

I am not really able to understand ur problem, but i believe you can use a function  getselectedcount(fieldname) = 1 to control your dimensions

[#3]

Sorry, I'll try to clarify.  I'm using the Count(DISTINCT(dimension))=1 to control what data is displayed, so for BL the condition is Count(Distinct(Division))=1.  This works fine.  However, for Desk, the condition Count(DISTINCT(BL))=1 only works when I select a single month-year period like in the final screenshot above.  When a single BL is selected I want the Desk(s) to show regardless of the number of months selected. (Hope this helps clarify)

I tried getselectedcount(fieldname) = 1 but had the same issue.

[#4]

for BL show/hide condition (when one Division is selected) is true even when u select one BL. may be you write something like.

BL show hide condition : getselectedcount(Division) = 1 and getselectedcount(BL) =0

if you can provide a sample file, it will be easier.