Create a flag

[#1]

Afternoon all,

I'm struggling with the basics here I'm afraid.

I have a set of data where payments have been made, by each customer, for each month of the year. I can get this into a simple Pivot table and this works fine.

What i would like to be able to do is create a filter - so that the table only reports on policies where the amount has changed during the year. For exmaple Policy 2 (Mr Wallis) had a payment of £40 in August when all of his other payments were £60.

So by filtering on "Policies with a change of payment" I would only expect to see policies 2 and 6.

Can anyone suggest a method?

thanks very much

Chris.

[Gysbert_Wassenaar · Accepted solution]

See attached example

[#3]

Thanks very much.

Works a treat.

I shall research the component parts of your answer to try and learn from it.

aggr(only({<Policy={'=count(distinct Amount)>1'}>} Policy),Policy)

Would it be possible to have it in the script - so that then the flag could be in a list box - allowing the user to select either "all" or just the policies with changes?

thanks again

Really appreciate your help.

Chris

[#4]

Hi Chris,

just another example, as I love if() more than Set Analysis.

RR

[#5]

Hi Chris,

best would be to send example file (with source data). Then someone can code the load - script accordingly.

RR

[Gysbert_Wassenaar]

See attached qvw for a script based solution.

[#7]

Many thanks to both of you.

Much appreciated.