topic create more recs, than in the source in QlikView

create more recs, than in the source

Fri, 24 Oct 2014 07:43:17 GMT

Hi!

Can anyone tell me, if its possible to make a table with more records than a source table had, but during the load, not loading and joining afterwards with another table?

I mean so that one parent record in a source table have few descendant-records in the result table

Thanks in advance

Re: create more recs, than in the source

Fri, 24 Oct 2014 07:57:27 GMT

can nested loads be helpfull?

Re: create more recs, than in the source

Colin-Albert — Fri, 24 Oct 2014 08:01:15 GMT

Can you give an example of what your source data is and the output you expect?

Re: create more recs, than in the source

Fri, 24 Oct 2014 08:10:53 GMT

Colin, thank you for responce!

I'm trying to create an app, that calculates debts by periods..

I need to see debts of partners, dew to their "age": wich debts are less then month, which 1-3 months, which 3-6 months... (the best- to be able to choose the limits in the app by user....) User want to see it in different lines or colours of bars..

the payment scheme is FIFO: the new cash transfer goes to repay the oldest debt... So there are "steps"... So I see it like a parent record- the clients debt&start_date and few few descendant-records (repyed part_date of payment), if the debt was not repayed immidiately (was prepeyed)

I need to receive smth like marked in yellow in the end

Re: create more recs, than in the source

Fri, 24 Oct 2014 08:22:11 GMT

Gysbert Wassenaar, I received an email, that said you replied, but cant see your answer here.

You said its possible... Could you tell me, please,how can I do that? What operators/functions to use?

Thank you in advace

Re: create more recs, than in the source

Fri, 24 Oct 2014 08:29:47 GMT

I really mean a new record, not a new field in existing record