Ps answer on this.

nevilledhamsiri — Sat, 12 Aug 2017 14:28:06 GMT

I need to calculate penalty of Rs250 for each cancelled policies. I base their reference numbers to do this.But some reference numbers are repeated & I should do the above calculation excluding those repeated numbers.In other words, Rs 250 to be charged only against one reference number. Here the reference numbers are dimension & the related premium value due to these reference numbers too are assigned which is a expression. To make this clear, I may present my case as below:

Ref_Number Class Policy_Number Premium(Rs)

RA000C125 MC RA1C 500

RA000C125 MC RA1C 250

RA000C128 FR RA1D 320

RA000C150 FR RA1K 250

EM000C200 MC EM1A 100

EM000C300 FR EM1B 200

EM000C200 MC EM1A 50

I have written expression as follows!

sum({<Ref_Number={'MC'}>}250)

As per above, Rs 250 is calculated twice on RA000125, EM000C200 Ref numbers. Help me to avoid this by having included some logic in to my above set analysis.

Thanks.

Neville

Re: Ps answer on this.

rubenmarin — Sat, 12 Aug 2017 15:02:19 GMT

Hi Neville, it's not clear to me what you want to do with duplicated records, can you post a sample data and the result you expect?

Also, why is Ref_Number in set analysis?, 'MC' only exists in Class field.

Maybe is easier to flag the 'penalty' records in script.

Re: Ps answer on this.

sunny_talwar — Sat, 12 Aug 2017 17:02:07 GMT

Please try not to ask the same question multiple times

repeated issue

To avoid calculation on repeated reference numbers‌

‌Ps answer on this.

topic Re: Ps answer on this. in QlikView

Ps answer on this.

Re: Ps answer on this.

Re: Ps answer on this.