topic Re: Set Analysis and Alternate State in App Development

Set Analysis and Alternate State

Tue, 15 Aug 2017 20:12:27 GMT

Dear Community Experts,

I am facing an issue with Set Analysis and Alternate State using a Variable.

Same Expression is working fine with out any Alternate State but not working in Alternate Statement.(Different Variable created)

=sum({<[Field1]={"abcd"},[Q & Y Name]={"$(VCurrentQtr)"},Month=,Year=>} [Amount])

Please help.

Re: Set Analysis and Alternate State

sunny_talwar — Wed, 16 Aug 2017 11:44:39 GMT

Where is the alternate state here? Can you may be share a sample to show what is not working?

Re: Set Analysis and Alternate State

Fri, 01 Sep 2017 18:52:30 GMT

Thanks Sunny for the reply I have fixed it, but I have one more issue. I am using expression like below and it is giving right result for selected period.

Sum(if(Aggr(Avg(TOTAL <[Field1]> [ Rollups)])>'12', [Field1]),1,0))

But I want rolling 6 periods on line chart and when I am trying to use set Analysis it is not working.

Please help.

Thanks in advance.