Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Sum(Claims)/Sum({<Coverage={'A'}>} TOTAL Exposures)
HTH
Best,
S
Try this:
Sum(Claims)/Sum({<Coverage={'A'}>} TOTAL Exposures)
HTH
Best,
S
Kudos for Sunindia..
Or something like this:
=Sum(Claims) / Sum(ALL {<Coverage={'A'}>} Exposures)
Grtz. Fred
Thank you both for the help. Something so simple I missed. Well done!
Justin
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.