topic Re: Create a flag in QlikView

Create a flag

Fri, 07 Mar 2014 15:37:51 GMT

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.

Re: Create a flag

Gysbert_Wassenaar — Fri, 07 Mar 2014 15:48:52 GMT

See attached example

Re: Create a flag

Fri, 07 Mar 2014 15:58:26 GMT

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

Re: Create a flag

Fri, 07 Mar 2014 15:58:54 GMT

Hi Chris,

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

Re: Create a flag

Fri, 07 Mar 2014 16:35:51 GMT

Hi Chris,

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

Re: Re: Create a flag

Gysbert_Wassenaar — Fri, 07 Mar 2014 16:39:32 GMT

See attached qvw for a script based solution.

Re: Create a flag

Fri, 07 Mar 2014 16:42:57 GMT

Many thanks to both of you.

Much appreciated.