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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

Dividing by Avg Where

Hello,  I have a table and which has months in the first column and an AVG field in the second,  I need a formula that divides the AVG Month figures by a specific months AVG. 

For example each months Avg Figure divided by the Avg figure for Jan 2020 (202002).

 

Any Ideas?

Labels (1)
1 Reply
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

try to create the value in a variable, then use that inside the expression.