Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
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)
1 Reply

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

Community Browser