Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How do you exclude some selection fields from an aggregate expression?

Hi,

I hope someone can help - I have an expression which works fine for establishing a sepcific 'actual' average criteria as well as remove duplicates:-

avg(aggr(avg({$<Type={'Total Bill'},[Team Type Summary]={'FTO','Trainee'}, [BillAveExclude] -= {'1'},[Claim Type]={'Fast Track RTA'}>}Distinct [Client Damages]),Case))

To get to the 'plan' for this area I want to take department wide average and display this against the 'actual' average based on any current selections.  To this end I believe that I need to incorporate the instruction to ignore certain field selections into the set analysis:-

[Site Summary]=,[Senior Manager Summary]=,[FE Team Summary]=,[Fee Earner Summary]=

My issue is how to position the ignore selections instruction within the original expression - if I include as part of the current structure it does not ignore these selections and therefore my 'plan' figure continues to mirror my 'actual' based on various selections.

Any help would be greatly appreciated!!

Thanks

1 Reply
Not applicable

How do you exclude some selection fields from an aggregate expression?

Has anyone had any thoughts on this?  My deadline is fast approaching