Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Mcvein
Contributor
Contributor

How to remove the effect of dimension when calculating the measures

Hi all, I'm new to Qlik and tried to search this in community but failed. Any suggestions on how to write the expressions ot "total amount"?

Dimension: week

Amount: = sum([amount])

total amount: I tried using <week=> and {1} but not helping

week amount total amount %
1 10 150 7%
2 20 150 13%
3 30 150 20%
4 40 150 27%
5 50 150 33%

 

 

 

Labels (6)
2 Solutions

Accepted Solutions
marcus_sommer

Try it with: sum(total [amount])

View solution in original post

Chanty4u
MVP
MVP

try this

 

 sum({1<Week=e(Week)>}[amount])

 

or

sum(Amount)/Sum(Total <Week> Amount)

View solution in original post

2 Replies
marcus_sommer

Try it with: sum(total [amount])

Chanty4u
MVP
MVP

try this

 

 sum({1<Week=e(Week)>}[amount])

 

or

sum(Amount)/Sum(Total <Week> Amount)