topic Autogenerate from Resident Table in QlikView

Autogenerate from Resident Table

Fri, 08 Jun 2012 11:17:02 GMT

Hi Guys and Gals,

I'm having some trouble trying to figure this one out and would like some help achieving this output.

I have a resident table with say 3 account fields, 3 account values and 3 account dates

AccountField, AccountValue, AccountDate

A, 100, 2010/10/01

B, 200, 2010/10/01

C, 300, 2010/10/01

In the front end of the report there is 6 variables ( 2 by 3) that I want to apply an increase to the above AccountValue fields that the EU will decide.

So variable 1 will be for account A and says apply increase in Mar {Mar being the actual value they have selected}, variable 2 will say select the amount that the variable must increase by, EU select 5% {5% the value the accountvalue will increase by}

I want to autogenerate based on this above information a table of values taking into account these input fields. The last condition is that this information is annual and that the % increase will always be applied to the last value in the month before it applies. Below is an output example of account A

AccountField, AccountValue, AccountDate

A, 100, 2010/10/01

A, 100, 2010/11/01

A, 100, 2010/12/01

A, 100, 2011/01/01

A, 100, 2011/02/01

A, 105, 2011/03/01

A, 105, 2011/04/01

A, 105, 2012/02/01

A, 110.25,2012/03/01

and so forth for the number of months i want to autogenerate for. I'm really hoping there is someone out there that has attempted this type of autogenerate off some preloaded information and applied inputs as illustrated above.

Thanking all in advance

Cheers,

Byron

Re: Autogenerate from Resident Table

vincent_ardiet — Fri, 08 Jun 2012 12:46:38 GMT

Hi,

May be you should try to write a loop (with a do...loop or a for...next) instead of an autogenerate ?

On each iteration you can test the month and concatenate a new line in your target table.

Regards,

Vincent

Autogenerate from Resident Table

Fri, 08 Jun 2012 12:58:07 GMT

Hi Vincent,

Thanks for your reply, I haven't yet used a for while loop I know shocking lol, but none-the-less will read up on it and give it a try. In the mean time was playing around a bit and the while ... iterno() seems to be doing a pretty good job atm in 'generating' additional fields as I would like them, but will be tricky once i start to include the variables.

Anyway, let me stop waffling, going to read up on the do while loop now and let you know how successful that was!

Cheers,

Byron

Re: Autogenerate from Resident Table

Tue, 12 Jun 2012 06:55:36 GMT

the for while loop did achieve what I was looking for. I am just completing the script and will be posting the qv file for anyone coming across this post as the script solution for this problem

Kind regards,

Byron

Re: Autogenerate from Resident Table

Anonymous — Mon, 02 Sep 2013 11:38:21 GMT

Hi Byron,

Would you be so kind as to post the script? I have a similar conceptual problem.

Thanks,

Antoine

Re: Autogenerate from Resident Table

Mon, 16 Sep 2013 12:59:40 GMT

Hi Antoine,

I actually resolved this quite a while ago. Will have a look for the script and post it here for you. Hope it is what you were looking for

Cheers,
Byron

Re: Autogenerate from Resident Table

Anonymous — Mon, 16 Sep 2013 13:14:09 GMT

Hi Byron,

Thanks alot.

I managed to solve it using IterNo() function. Îf you have an alternative manner, I would more than happy since I am looking at generating quite some considerable amount of records (optimise )

Thanks,
Antoine