Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - Fail to show the benchmark value

I have a Table:

 

IDDAYMONEY
1MON1
1TUE2
2MON3
2TUE4
3MON5
3TUE6
BenchmarkMON7
BenchmarkTUE8

Want to compare the benchmark like below

 

IDDAYMONEYBenchmark
1MON17
1TUE28
2MON37
2TUE48
3MON57
3TUE68
BenchmarkMON77
BenchmarkTUE88

To achieve this,

I have selected 'ID' and 'Day' as dimensions,

'MONEY' is the expression and the benchmark expression sum({$<ID={4}>}MONEY)

but the result turns out

 

IDDAYMONEYBenchmark
1MON10
1TUE20
2MON30
2TUE40
3MON50
3TUE60
4MON77
4TUE88

What is wrong in my work?

2 Replies
swuehl
MVP
MVP

Try

sum(TOTAL<DAY> {$<ID={4}>}MONEY)

Not applicable
Author

Let me try,thanks