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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combining multiple conditions on a measure

I have a measure which has to show data based specific accounts and sum it all up to the date selected in filter.

I have created this so far and I don't understand how to combine these two expressions in the same measure

1. Sum({$<account = {1,2,3,}>},amt)

2. Sum({$<year = {=max(year)}>},amt)

I tried creating variable for one of the conditions and still couldn't get this to work. Can someone please correct me.

13 Replies
Not applicable
Author

This works fine, but I don't understand what happens when I use year or month instead of yearmonth.

sunny_talwar

Why do you want to use Year and Month when YearMonth together is working for you?

Not applicable
Author

It didn't look that great from UI point of view. If you have any more insights, please do share.

Thank you so much for all your help.

sunny_talwar

Just so you know, you can still make selections in Year and Month fields. The expression will still give you the right output.