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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
pala_jagadeesh
Contributor III
Contributor III

How to Calculate BMI

Hi I have height ( in centimetes)  and Weight  (in kgs)columns, From this How to calculate BMI

Height(cm) Weight(kg)
168 75
180 78
178 85
Labels (3)
1 Solution

Accepted Solutions
EliGohar
Partner - Specialist
Partner - Specialist

@pala_jagadeesh 

If you want to add the BMI calculation to the client, You can add a measure to the straight table with the following formula:

(Weight/[Height(cm)]/[Height(cm)]) * 10000

 

Result:

EliGohar_0-1672659989943.png

 

Eli.

 

View solution in original post

3 Replies
EliGohar
Partner - Specialist
Partner - Specialist

@pala_jagadeesh 

If you want to add the BMI calculation to the client, You can add a measure to the straight table with the following formula:

(Weight/[Height(cm)]/[Height(cm)]) * 10000

 

Result:

EliGohar_0-1672659989943.png

 

Eli.

 

aranjan
Contributor
Contributor

To calculate BMI (Body Mass Index) using height in centimeters and weight in kilograms, you can use the following formula:

BMI = weight (kg) / (height (m) × height (m))

Since your height is in centimeters, you'll first need to convert it to meters by dividing it by 100.

Here’s how it works for your data:

  1. 168 cm / 75 kg
    → Height in meters = 1.68
    → BMI = 75 / (1.68 × 1.68) ≈ 26.57

  2. 180 cm / 78 kg
    → Height in meters = 1.80
    → BMI = 78 / (1.80 × 1.80) ≈ 24.07

  3. 178 cm / 85 kg
    → Height in meters = 1.78
    → BMI = 85 / (1.78 × 1.78) ≈ 26.80

If you want a faster way to calculate and visualize BMI ranges, you can use this free tool I created:
👉 https://FullBMICalculator.com
It supports metric and imperial units, BMI classification, health tips, and more.

Hope this helps!

seanbruton

This was an Interesting post. Thanks i learnt something new.