# 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
Did you mean:
Creator

## Set Analysis help

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

1 Solution

Accepted Solutions
MVP

Try this:

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

HTH

Best,

S

4 Replies
MVP

Try this:

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

HTH

Best,

S

Partner - Specialist

Kudos for Sunindia..

Or something like this:

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

Grtz. Fred

Creator
Author

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

Justin

MVP

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.

Community Browser