Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

benwspx1
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

1 Solution

Accepted Solutions
MVP
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
MVP

Re: New to Set Analysis - Expression failing

How is $(vPeriodCurrentMonth) defined?

benwspx1
New Contributor III

Re: New to Set Analysis - Expression failing

Updated with actual definition:

{<
[Fiscal Period Counter Month] = {"$(=max([Fiscal Period Counter Month]))"}
>}
MVP
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])

benwspx1
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!