topic Re: generation of data in QlikView

generation of data

Fri, 18 Oct 2013 13:28:57 GMT

I need to generate some data I don't have, result looks very simple, but I don't know how to do it - I don't want create excel table.

I have to calcute available time for each production line, but they are available also during days when there was no production, so I gues I have to generate also dates.

How can I do this?

Thank for help.

result I need:

Re: generation of data

Anonymous — Fri, 18 Oct 2013 13:45:42 GMT

Klaudia

In the Script Editor do:

Insert
Test Script

You'll see it adds in some test data generation code.

This includes examples of autogenerate and while.

You should be able to use this as inspiration to generate you specific test data.

Best Regards, Bill

Re: generation of data

Gysbert_Wassenaar — Fri, 18 Oct 2013 14:16:37 GMT

Perhaps this document will give you some ideas: Generating Missing Data In QlikView

Re: generation of data

ngulliver — Wed, 05 Mar 2014 20:14:17 GMT

Hi, Klaudia.

Just a tip -

If you go into your edit script and with Crtl key pressed, type Q twice (so that's CTRL Q Q),

it will automatically create a script which generates some test data for you. You may be able to amend the script to suit your requirements.

Regards,

Neil.