Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.