# New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Search instead for
Did you mean:
Creator III

## Qlik Sense Set Analysis

Hi All,

I have a lot of measures where measures are defined as below.

01. Abs Sales = sum({<country={'India'}>}sales)/sum(total{<country={'India'}>}sales)

02. Rel Sales = (sum({<country={'India'}>}sales)/sum(total{<country={'India'}>}sales) )

/sum({<country={'US'}>}sales)/sum(total{<country={'India'}>}sales)

These are sample def. of my Qlik Measures.

My question is what is the difference between sum/sum(total{some filter})

Above example, you can see both numerator and denominator are the same only in denominator we have extra which is total.

Please, anyone, reply for this once you will get an idea what this,

Thanks in Advance.

Thanks & Regards

Vivek Anand

Labels (1)
• ### Qlik Sense

1 Solution

Accepted Solutions
Specialist III

for example ur dimension is month

Sum(sales) will show different value for each month per india

but SUM(Total sales) it will show same value for all months which is total of all months

hope it is clear

Channa
1 Reply
Specialist III

for example ur dimension is month

Sum(sales) will show different value for each month per india

but SUM(Total sales) it will show same value for all months which is total of all months

hope it is clear

Channa
Tags
Community Browser