topic Dependant fields, or mandatory selection in QlikView

Dependant fields, or mandatory selection

m4u — Sun, 20 Dec 2009 22:47:30 GMT

Hello

Please advice on how to handle the following scenario:

I have two tables - upper table showing a list of service calls, and a lower table showing a list of comments added by various support representatives to the currently selected service call.

I would like the lower table become visible or full with information only when user selects a certain service call id field in the upper table, since otherwise the results of the lower table have no meaning whatsoever (its just a list of text comments with dates, not even call id is displayed)

How can I do that? I need some way of telling the system to show the data only if the CallID field is in the selection..

Thanks

Dependant fields, or mandatory selection

Mon, 21 Dec 2009 03:23:48 GMT

You have 2 options:

- General -> Calculation Condition (object is shown, but it will show data only when condition is true)

- Layout -> Show -> Conditional (object is shown only when condition is true)

Dependant fields, or mandatory selection

m4u — Mon, 21 Dec 2009 23:59:18 GMT

Ok.. and what condition should I specify in order to tell whether a field is currently selected?

Dependant fields, or mandatory selection

rwunderlich — Tue, 22 Dec 2009 06:32:08 GMT

=GetPossibleCount(CallID) = 1

-Rob