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/Officia...
https://community.qlik.com/t5/QlikVie...
QlikFix.com
https://www.qlikfix.com/2014/03/14/ge...
You can also find me on
YouTube: / @manishkumarkachhia1683
Facebook: https://www.facebook.com/profile.php?...
LinkedIn: / manishkachhia
Twitter: / mk_qsl
Udemy: https://www.udemy.com/user/manish-kac...
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