Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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.