topic Re: Capping by Group in QlikView

Capping by Group

Tue, 28 May 2013 20:20:53 GMT

Hi All,

I'm trying to create a load script that will create column E.

Essentially I'm trying to cap my transaction by column A, column B represents transaction sorted by time.

Thank you for your help.

Re: Capping by Group

Gysbert_Wassenaar — Wed, 29 May 2013 07:16:40 GMT

See attached qvw.

Re: Capping by Group

Wed, 29 May 2013 07:33:19 GMT

Gysbert,

Can you please share brief description steps, about the solution you posted.

Thanks,

Angad

Re: Capping by Group

Wed, 29 May 2013 13:13:43 GMT

Thank you very much for your help.

Re: Capping by Group

Wed, 29 May 2013 14:00:23 GMT

The only thing it doesn't do is Cap the first transaction row if it is above the cap.

Example, if the row1 column c had a value of 350. The code sows 350, it should show 250.

Re: Capping by Group

Wed, 29 May 2013 14:26:48 GMT

Made the small change to get the capping on the first row. Thank you again for your help.

if(previous(P)=P, if(previous(CumTrans) < $(vCap), rangemin(Transaction,$(vCap)-previous(CumTrans)),0),If(Transaction > $(vCap),$(vCap),Transaction)) as Cappd2