Qlik_078: How to generate random data using Qlik script using various Qlik functions?
In this video we will learn how to generate random data similar to real time project data in Qlik using various Qlik scripting functions. 00:00:01 – 00:00:22 Introduction 00:00:23 – 00:01:40 Qlik sample data using CTRL 0 0 keywords. 00:01:41 – 00:03:55 Generate random sales data like real time projects data. Generate Quantity 00:03:56 – 00:04:35 Generate OrderID or Order Number. 00:04:36 – 00:05:40 Generate Customer Name or Order Number. 00:05:41 – 00:07:00 Generate Product and Country. 00:07:01 – 00:09:25 Generate LineCostPrice and Cost. 00:09:26 – 00:12:45 Generate LineSalesPrice, Sales, LineProfit, Profit. 00:12:46 – 00:17:15 Generate OrderDate. 00:17:16 – 00:19:10 Generate OrderTime. 00:19:11 – 00:22:26 OrderDate and OrderTime align with OrderID. If you want to read few blogs on this topic. https://community.qlik.com/t5/Official-Support-Articles/How-to-create-a-small-sample-data-set-in-QlikSense-using-a-Ctrl/ta-p/1716004 https://community.qlik.com/t5/QlikView-App-Dev/Generate-Random-Data-from-Specific-Values/td-p/890448 QlikFix.com https://www.qlikfix.com/2014/03/14/generating-random-test-data-qlikview/ You can also find me on YouTube: https://www.youtube.com/channel/UCIiZOUP1Em4zHcA-ZICAijA Facebook: https://www.facebook.com/profile.php?id=100078673955648 LinkedIn: https://www.linkedin.com/in/manishkachhia/ Twitter: https://twitter.com/MK_QSL Udemy: https://www.udemy.com/user/manish-kachhia/ Website: https://qliksolutions.com/ #qlik #qliksense #qlikview #qs #qv #qlikdatamodel #qlikscript #set #let #setvariable #letvariable #variable #newtoqlik #newtoqliksense #newtoqs #newtoqlikview #newtoqv #learnqlik #beginnerqlik #trace #tracestatement #debug #Trace #tablefunctions #qlikfunctions #qlik #fieldname #fieldnumber #nooffields #noofrows #nooftables #qvd #storeqvd #createqvd #addyears #addmonths #date #time #dateandtimefunctions #monthstart #monthend #yearstart #yearend #pick #match #customisedreport #pivottable #networkdays #Genericload #fieldvaluecount #fieldvalue #tablename #loop #forloop #variableswithparameter #aggr #firstsortedvalue #Textbetween #QlikExtension #Extension #QVDMetaData #Dimensionality #EnvironmentalVariables #FirstWeekDay #BrokenWeeks #ReferenceDay #optimized #non-optimized #randomdata #testdata #sampledata #salesdata
In this video we will learn how to generate random data similar to real time project data in Qlik using various Qlik scripting functions. 00:00:01 – 00:00:22 Introduction 00:00:23 – 00:01:40 Qlik sample data using CTRL 0 0 keywords. 00:01:41 – 00:03:55 Generate random sales data like real time projects data. Generate Quantity 00:03:56 – 00:04:35 Generate OrderID or Order Number. 00:04:36 – 00:05:40 Generate Customer Name or Order Number. 00:05:41 – 00:07:00 Generate Product and Country. 00:07:01 – 00:09:25 Generate LineCostPrice and Cost. 00:09:26 – 00:12:45 Generate LineSalesPrice, Sales, LineProfit, Profit. 00:12:46 – 00:17:15 Generate OrderDate. 00:17:16 – 00:19:10 Generate OrderTime. 00:19:11 – 00:22:26 OrderDate and OrderTime align with OrderID. If you want to read few blogs on this topic. https://community.qlik.com/t5/Official-Support-Articles/How-to-create-a-small-sample-data-set-in-QlikSense-using-a-Ctrl/ta-p/1716004 https://community.qlik.com/t5/QlikView-App-Dev/Generate-Random-Data-from-Specific-Values/td-p/890448 QlikFix.com https://www.qlikfix.com/2014/03/14/generating-random-test-data-qlikview/ You can also find me on YouTube: https://www.youtube.com/channel/UCIiZOUP1Em4zHcA-ZICAijA Facebook: https://www.facebook.com/profile.php?id=100078673955648 LinkedIn: https://www.linkedin.com/in/manishkachhia/ Twitter: https://twitter.com/MK_QSL Udemy: https://www.udemy.com/user/manish-kachhia/ Website: https://qliksolutions.com/ #qlik #qliksense #qlikview #qs #qv #qlikdatamodel #qlikscript #set #let #setvariable #letvariable #variable #newtoqlik #newtoqliksense #newtoqs #newtoqlikview #newtoqv #learnqlik #beginnerqlik #trace #tracestatement #debug #Trace #tablefunctions #qlikfunctions #qlik #fieldname #fieldnumber #nooffields #noofrows #nooftables #qvd #storeqvd #createqvd #addyears #addmonths #date #time #dateandtimefunctions #monthstart #monthend #yearstart #yearend #pick #match #customisedreport #pivottable #networkdays #Genericload #fieldvaluecount #fieldvalue #tablename #loop #forloop #variableswithparameter #aggr #firstsortedvalue #Textbetween #QlikExtension #Extension #QVDMetaData #Dimensionality #EnvironmentalVariables #FirstWeekDay #BrokenWeeks #ReferenceDay #optimized #non-optimized #randomdata #testdata #sampledata #salesdata