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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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