Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
Try it with: sum(total [amount])
try this
sum({1<Week=e(Week)>}[amount])
or
sum(Amount)/Sum(Total <Week> Amount)
Try it with: sum(total [amount])
try this
sum({1<Week=e(Week)>}[amount])
or
sum(Amount)/Sum(Total <Week> Amount)