topic summarising specific values within a data set in QlikView

summarising specific values within a data set

Wed, 25 Jan 2012 14:08:35 GMT

Looking for some advice on how to achieve the following.

I have data loaded that contains a number of attributes. 1 being Business Rule Type.

I can get the summary of associated values using the expression below

Sum ({<[Business Rule Type]={'EBR'}>}[Passing Rows])

What I want to do is extend this further to take into account another criteria/

ie. The summary of Passing rows for (Business Rule Type = EBR and Business Rule Name = Null)

Reasoning is I wish to categorise the TYPES into other areas...

Regards

Robin

stephencredmond — Wed, 25 Jan 2012 16:03:25 GMT

Hi Robin,

You can use the -={} construct in the set to exclude nulls:

=Sum ({<[Business Rule Type]={'EBR'}, [Business Rule Name]-={}>}[Passing Rows])

Note that the -= may show as a syntax error but it is not.

Regards,

Stephen

Thu, 26 Jan 2012 09:30:42 GMT

Thanks Stephen, appreciate the support