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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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