Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

generation of data

Hi

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:

generate.JPG

3 Replies
Anonymous
Not applicable
Author

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
ngulliver
Partner - Specialist III
Partner - Specialist III

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.