topic Is there a function that works opposite to the previous() function ? in QlikView

Is there a function that works opposite to the previous() function ?

Mon, 07 Oct 2013 04:37:05 GMT

Instead of looking at who the new customers are, I would like to identify which customers have been churned out in the next period. So looking for a function that works opposite to the previous() function.

Re: Is there a function that works opposite to the previous() function ?

Mon, 07 Oct 2013 05:17:19 GMT

Hi,

The same previous condition itself can do your requirement

Just check if(previous(Customer)=Customer,'1','0') AS Flag

Here who having 1 the existing customer or they are the new one

Re: Is there a function that works opposite to the previous() function ?

Mon, 07 Oct 2013 05:32:54 GMT

Thanks Amutha.

I realized the same.

Re: Is there a function that works opposite to the previous() function ?

Anonymous — Mon, 14 Oct 2013 20:00:16 GMT

another variant:

IF(NOT Previous(Customer)=Customer,0,1)

Re: Is there a function that works opposite to the previous() function ?

Clever_Anjos — Mon, 14 Oct 2013 20:15:51 GMT

There´s no function to "look ahead" into dataflow to check what would be your next value to a field.

You should rewrite your logic as recommended by Amuthabharathi Subramanian

Re: Is there a function that works opposite to the previous() function ?

Gabriel — Mon, 14 Oct 2013 22:53:09 GMT

HI,

try Peek() function.

Best regards.

Re: Is there a function that works opposite to the previous() function ?

Tue, 14 Jan 2014 09:08:29 GMT

I'm looking to do something very similar. I have a field called 'FlowDirection'. If the record ahead has a value of 'Backwatrds' I want the field I'm creating to have 'Y' else 'N'. I don't quite see how I can fit this into the logic provided thus far.

Any help would be greatly appreciated.

Re: Is there a function that works opposite to the previous() function ?

Anonymous — Tue, 14 Jan 2014 11:31:30 GMT

is it dependent of the current field that is being analysed?

You can do it in 2 steps, first flag the FlowDirection with backwatrds as Yes in Flag 1.

then, reverse the sort order

and then use the Previous function to flag your final flag for this who have yes in Flag 1

Re: Is there a function that works opposite to the previous() function ?

Tue, 14 Jan 2014 13:34:43 GMT

Thanks eruditio, that work work spot on.

Re: Is there a function that works opposite to the previous() function ?

Anonymous — Tue, 14 Jan 2014 13:51:23 GMT

glad to be of help