Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
jsteyn26
New Contributor

Need to get the sum of an expression in a Pivot

Hi All

I need some help, been looking for a solution on the forums without any success.

I would like to get the sum of the values in row: Test displayed in each column.

So for Row

Test(A), I am expecting 1 in both "201901" and "201902"

Test(B), I am expecting 2 in both "201901" and "201902"

Test(C), I am expecting 2 in both "201901" and "201902"

Test(D), I am expecting 1 in both "201901" and "201902"


My Expression Used for Test is:

= sum(Aggr(if(sum(Actual) = 0, 1, 0), [BP Practice Code], [BP Adviser Code], [BP Provider Code], [BP Sub Group], [BP Period]))

Capture.PNG

I have also tried aggregating the expression by it's Label(ie. Test) but QV states: Bad Field Names

Capture2.PNG

Any assistance would be appreciated.

Regards