Qlik Community

New to Qlik Sense

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vanand3535
Creator III
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)
1 Solution

Accepted Solutions
Channa
Specialist III
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

View solution in original post

1 Reply
Channa
Specialist III
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

View solution in original post