Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variance Calculation

Hi

I am trying to caluate the variance between the quarters in a year, I have used the expression below



=(avg( {$< Quarter = { 'Q1' } >}[Total Average]) - avg( {$< Quarter = { 'Q2' } >}[Total Average])) / avg( {$< Quarter = { 'Q2' } >}[Total Average])

but i need to include this conditoin ({$<[Directorate]={'Surgery'}>})





please help







0 Replies