Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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

Labels (1)
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
Partner - Champion III
Partner - Champion III

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.