Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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