Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

expression problem

hello, please help me with a stupid problem, i will see the same week this year en previous year.
this expression dosn't work the table show the last week this year .
sum
({$<jaar={$(=max(jaar)-1) }>}{$<week={$(=max(week)) }>}[Aantal geleverd]
1 Solution

Accepted Solutions
MVP
MVP

expression problem

Use only one set expression, set modifier separated by comma:

sum
({$<jaar={$(=max(jaar)-1)}, week={$(=max(week))}>}[Aantal geleverd])

2 Replies
MVP
MVP

expression problem

Use only one set expression, set modifier separated by comma:

sum
({$<jaar={$(=max(jaar)-1)}, week={$(=max(week))}>}[Aantal geleverd])

Not applicable

expression problem

Thanx it works !!!

Community Browser