# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Contributor

## Calculated Condition - required 2 fields, optional 1 field

I need to write a calculated condition for an object that does the following:

Required selections:

Month and Year

Optional selections:

Department Name

Nothing else can be selected. Struggling with getting this to work.

Thanks in advance for any assistance!

Steve

Tags (1)
MVP

## Re: Calculated Condition - required 2 fields, optional 1 field

Steve

Have you looked at the GetFieldSelections() command ?

I often find it best to test such commands in a Text Box, using a Value Expression of say something like :

=GetFieldSelections( [YourFieldName])

Then when you have seen what it returns when you do various selections on YourFieldName, then you can build your Calculation Condition Expression.

Best Regards,     Bill