Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

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

1 Reply
Anonymous
Not applicable

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