topic Re: Set Analysis help in QlikView

Set Analysis help

Anonymous — Fri, 13 Mar 2015 19:43:22 GMT

Hello,

I am looking for help on a straight table. I am trying to figure out the frequency based off of a common demoninator. My data simplified is as follows:

Coverage, Claims, Exposures

A, 100, 25

B, 200, 0

C, 300, 0

D, 400, 0

What I am trying to create a table with Coverage as the Dimension, and an expression that is:

Sum(Claims)

Sum({<Coverage={'A'}>})

I assume this may be a fairly easy answer, but I am only getting a result in the table for Coverage A, where I would like B, C, D to be divided by 25. In the example, the data is monthly, so it will need to change if the user selects a different month.

Thank you,

Justin

Re: Set Analysis help

sunny_talwar — Fri, 13 Mar 2015 19:59:35 GMT

Try this:

Sum(Claims)/Sum({<Coverage={'A'}>} TOTAL Exposures)

HTH

Best,

Re: Set Analysis help

fred_s — Fri, 13 Mar 2015 20:05:36 GMT

Kudos for Sunindia..

Or something like this:

=Sum(Claims) / Sum(ALL {<Coverage={'A'}>} Exposures)

Grtz. Fred

Re: Set Analysis help

Anonymous — Fri, 13 Mar 2015 20:22:32 GMT

Thank you both for the help. Something so simple I missed. Well done!

Justin

Re: Set Analysis help

Nicole-Smith — Fri, 13 Mar 2015 20:38:46 GMT

Be careful if using all:

In previous QlikView versions, the all qualifier may occur before an expression. This is equivalent to using {1} total. In such a case the calculation will be made over all the values of the field in the document, disregarding the chart dimensions and current selections. (The same value is always returned regardless of the logical state in the document.) If the all qualifier is used, a set expression cannot be used, since the all qualifier defines a set by itself. For legacy reasons, the all qualifier will still work in this QlikView version, but may be removed in coming versions.