topic Re: Yet another Set Analysis question- no aggregation in QlikView

Yet another Set Analysis question- no aggregation

Thu, 31 Jan 2013 12:37:46 GMT

In a table I tried to use:

=if(ACTUALGENERALSETTLEMENT > 0,

if(YEAROFSETTLEMENT <> '9999',

sum(Severity)))

But this did not work (not sure why) so I used the following set analysis and it worked:

=sum({$<[YEAROFSETTLEMENT] -= {"9999"}>*<[.ACTUALGENERALSETTLEMENT] = {">0"}>} [Severity])

I am now trying to create a chart where I would like to show the Claim number if:

=if(ACTUALGENERALSETTLEMENT > 0,

if(YEAROFSETTLEMENT <> '9999',

ClaimNo))

The problem I have is that I cannot use the set analysis without an aggregation function and I just want the claim number displayed if it matches my criteria.

Is there a way I can use the set analysis without the need for aggregation?

Regards

Jason

Re: Yet another Set Analysis question- no aggregation

Gysbert_Wassenaar — Thu, 31 Jan 2013 12:58:04 GMT

Is this a calculation dimension you're trying to construct? Then you can either use your if statement or set expression with an aggregation. A set analysis expression returns only one value. If you need a list of values then you need to use an aggregation.

Re: Yet another Set Analysis question- no aggregation

Thu, 31 Jan 2013 13:09:39 GMT

No it is for an Expression.

I have tried using my If statement and it does not exlude a claim where the ACTUALGENERALSETTLEMENT = 0. Therefore it does not work.

As a similar if statement did not work for the table, I assumed this if statement did not work for the same reason when used in the chart.

The chart is a Grid Chart:

Dimension(2) - Expected Settled and Settled

Expression - as above

Regards

Jason