Qlik Community

Qlik Sense App Development

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

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

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
Highlighted

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])

View solution in original post

4 Replies
Highlighted

Re: New to Set Analysis - Expression failing

How is $(vPeriodCurrentMonth) defined?

Highlighted
Contributor

Re: New to Set Analysis - Expression failing

Updated with actual definition:

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

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])

View solution in original post

Highlighted
Contributor

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!