Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

sum with a concatenation of 2 fields

Hi guys,

I need help about a sum with a concatenation of 2 fields.

I have to Sum my budget for a specific Year (max year) and for a specific month.

Now I have this expression:

sum({$<YEAR={$(=max(YEAR))}>}Budget)

and it works perfectly.

So, i tried to add the new field in my expression and I wrote:

sum({YEAR ={$(=max(YEAR))},Month={$(=Only(Month))}}Budget)

Unfortunately I made a mistake in somewhere and I can't try if my expression is correct or no.

What's wrong in my expression ?

Thanks a lot

1 Solution

Accepted Solutions
Not applicable

sum with a concatenation of 2 fields

The '<' & '>' are missing in your expression. Check if the following works:

sum({<YEAR ={$(=max(YEAR))},Month={$(=Only(Month))}>}Budget)

View solution in original post

2 Replies
Not applicable

sum with a concatenation of 2 fields

The '<' & '>' are missing in your expression. Check if the following works:

sum({<YEAR ={$(=max(YEAR))},Month={$(=Only(Month))}>}Budget)

View solution in original post

Not applicable

sum with a concatenation of 2 fields

Thanks a lot it works.

Too concentrate to other things and I didn't see the obvious.

Again, Thanks.