Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hi

hi

1 Reply
swuehl
MVP
MVP

Please read Henric's blog post

http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations

to understand why the expression returns NULL when there are two Allocated Resource values possible.

(Try an aggregation function like sum([Allocated Resource]) )

You might also want to review your data model, I think proper linking your tables should remove your need for the if() statement, as far as I've understood your current model).