# Qlik Sense App Development

New Contributor III

## New to Set Analysis - Expression failing

Here's the expression:

sum(\$(vPeriodCurrentMonth),{\$<[LTC Type] = e({<[LTC Type]={' '}>} [LTC Type])>} [Prod Lbr Hrs])

Modifier 1 = \$(vPeriodCurrentMonth)

Modifier 2 = {\$<[LTC Type] = e({<[LTC Type]={' '}>} [LTC Type])>}

I've verified that each modifier works independently but they wont work together. Any help on how to get them to work together would be appreciated!

Thanks!

Ben

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: New to Set Analysis - Expression failing

Try this:

Sum({\$<[Fiscal Period Counter Month] = {"\$(=max([Fiscal Period Counter Month]))"}, [LTC Type] = e({<[LTC Type]={' '}>} [LTC Type])>} [Prod Lbr Hrs])

4 Replies
MVP

## Re: New to Set Analysis - Expression failing

How is \$(vPeriodCurrentMonth) defined?

New Contributor III

## Re: New to Set Analysis - Expression failing

Updated with actual definition:

 {< [Fiscal Period Counter Month] = {"\$(=max([Fiscal Period Counter Month]))"} >}
MVP

## Re: New to Set Analysis - Expression failing

Try this:

Sum({\$<[Fiscal Period Counter Month] = {"\$(=max([Fiscal Period Counter Month]))"}, [LTC Type] = e({<[LTC Type]={' '}>} [LTC Type])>} [Prod Lbr Hrs])

New Contributor III

## Re: New to Set Analysis - Expression failing

I had to modify it to this:

Sum({\$<[Fiscal Period Counter Month] = {\$(=max([Fiscal Period Counter Month]))}, [LTC Type] = e({<[LTC Type]={' '}>} [LTC Type])>} [Prod Lbr Hrs])

basically, just removed the quotes around =max and then had to relink the field names. Thanks!