topic Re: Enable Conditional for Dimensions in QlikView

Enable Conditional for Dimensions

Tue, 01 Apr 2014 18:35:57 GMT

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

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

Re: Enable Conditional for Dimensions

Tue, 01 Apr 2014 18:50:24 GMT

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

Re: Enable Conditional for Dimensions

Tue, 01 Apr 2014 19:01:59 GMT

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.

Re: Enable Conditional for Dimensions

Tue, 01 Apr 2014 19:10:55 GMT

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.