Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jtanguay
Creator
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
sunny_talwar

Try this:

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


HTH


Best,

S

View solution in original post

4 Replies
sunny_talwar

Try this:

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


HTH


Best,

S

fred_s
Partner - Specialist
Partner - Specialist

Kudos for Sunindia..

Or something like this:

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

Grtz. Fred

jtanguay
Creator
Creator
Author

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

Justin

Nicole-Smith

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.