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

Alternative state

Hello All,

I have a table which is in State A:

QuestionNoteTestCumulative 2016
QA125.5%32.0%45%

I have current selection of Month and Make for this state.

However, I want that the cummulative 2016 to bypass the state and cummulate the results of this current year.

I am using the expression below for the cummulative but the result is wrong:

=Sum({<Annee={">=$(=Max(Annee))"},QA1={'<>NSP'}>}QA1)/Count({<Annee={">=$(=Max(Annee))"},QA1={'<>NSP'}>}QA1)

Any idea?

Many Thanks,

Hasvine

1 Reply
sunny_talwar

May be this:

=Sum({<Annee={">=$(=Max(Annee))"},QA1={'<>NSP'}, State>}QA1)/Count({<Annee={">=$(=Max(Annee))"},QA1={'<>NSP'}, State>}QA1)


If this doesn't work, would you be able to provide a sample?