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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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







Labels (1)
0 Replies