topic Set Analysis in QlikView

Set Analysis

krishna20 — Sun, 29 Jun 2014 08:44:46 GMT

Hi friends !

I have to find outstanding amount for the claims paid of whole year.

for e.g.,

There is loss occurred on date 20-05-2013.

It intimated to company on 25-05-2013 loss occurred of 20000/-.

on 31-07-2013 we settled a amount of 5000 and remaining amount is 15000.

on 29-11-2013 we settled a amount of 6000 and remaining amount is 9000.

Now ,i need to find out the outstanding amount for the year of whole claims

I'm having the variables vCurrentYear,vCurrentYear-1 and vCurrentyear-2.

Currency field is CE_AMT_LC1.

Anyone pls suggest me how to apply set analysis for this situation ASAP.

Advance thanks,

Regards

krishna

avinashelite — Mon, 07 Jul 2014 07:59:01 GMT

Hi Kalyan,

Please find the attached QVW file for solution.

Hope this is what your looking for.

Regards,

@vi

krishna20 — Mon, 07 Jul 2014 09:10:34 GMT

Hi Avinash.

I didnt find any attachment.Please send me again.

Regards

Krishna

avinashelite — Mon, 07 Jul 2014 09:18:56 GMT

Hi Kalyan,

Please find the attached QVW file for solution.

Hope this is what your looking for.

Regards,

Anonymous — Mon, 07 Jul 2014 09:28:39 GMT

Hi,

Below set analysis script may help you to calculate remaining_amount,

Sum({<date_field={"$(=Date(Max(date_field)))"}>} remaining_amount)