Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Alternate states in set analysis

Hi,

Could someone help me in understanding what is wrong with the below expression. I have to use two alternate states for this expression hence alt1 and alt3.

=if (GetSelectedCount([Com Service Group])<>0 and GetFieldSelections([ComPeriod]) ='YTD', sum({alt1*alt3<FY_SH20 = {'2017'},Entity_SH20 = {'APAC'},Period_SH20 = {'YTD'}, Month_SH20 = {'Nov'}>}  Hours_SH20))

Thanks!

Arun

3 Replies
sunny_talwar

Looks fine to me, what is the issue that you are seeing?

Not applicable
Author

The expression is not working for for the second alternate state.

sunny_talwar

Unless you elaborate on what is not working, I don't think we will be able offer much help. Try to provide a sample or provide more details