Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
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)