Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
FilippoValli
Contributor III
Contributor III

Can anybody explain why set expression isn't working correctly?!

Hello,

I'm really struggling to understand why the set analysis of KPI n°2 isn't working correctly.

Anybody could help??

This is the Fx generating problems:

SUM({$<Campo_1=>}aggr(Campo_2, Campo_3))

 

In attachment a very simple QVF.

Thanks in advance.

Filippo

1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum({$<Campo_1=>}Aggr(Only({$<Campo_1=>} Campo_2), Campo_3))

View solution in original post

2 Replies
sunny_talwar

Try this

Sum({$<Campo_1=>}Aggr(Only({$<Campo_1=>} Campo_2), Campo_3))
FilippoValli
Contributor III
Contributor III
Author

AWESOME!! Thank you Sunny_talwar it's working exactly as expected.