Manish Kachhia
Manish Kachhia
  • 92
  • 260 394
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.
community.qlik.com/t5/Official-Support-Articles/How-to-create-a-small-sample-data-set-in-QlikSense-using-a-Ctrl/ta-p/1716004
community.qlik.com/t5/QlikView-App-Dev/Generate-Random-Data-from-Specific-Values/td-p/890448
QlikFix.com
www.qlikfix.com/2014/03/14/generating-random-test-data-qlikview/
You can also find me on
UA-cam: ua-cam.com/channels/IiZOUP1Em4zHcA-ZICAijA.html
Facebook: profile.php?id=100078673955648
LinkedIn: www.linkedin.com/in/manishkachhia/
Twitter: MK_QSL
Udemy: www.udemy.com/user/manish-kachhia/
Website: 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
Переглядів: 1 276

Відео

Qlik_077: How to convert non-optimized QVD load to optimized QVD load by simple technique.
Переглядів 1,4 тис.Рік тому
In this video, we will see techniques to convert non-optimized QVD load to optimized QVD load. 00:00:01 Introduction 00:01:40 Technique to load only few years data from a QVD using Year field 00:04:35 Technique to load only few years data from a QVD using Date field. If you want to read few blogs on this topic. Bitmetric www.bitmetric.nl/blog/qlik-optimized-load/ Qlik-Community community.qlik.c...
Qlik_076: What is Optimized and Non-Optimized QVD Load?
Переглядів 1,9 тис.Рік тому
In this video, we will see things which can define optimized QVD load and unoptimized QVD load. 00:00:01 Introduction 00:00:46 Optimized QVD Load example 00:03:35 Non-Optimized QVD Load example 00:05:30 Use of where condition 00:06:15 Use of Single Where Exists 00:07:00 Use of Multiple Where Exists 00:08:00 Use of Single Where Exists with different field name 00:09:05 Renaming field names or al...
Qlik_075: How Environmental Variables for Weeks works in Qlik?
Переглядів 843Рік тому
In this video, we will see how Environmental Variables for Weeks works in Qlik? We will also see how to modify them and get our desired output. 00:00:01 - 00:01:03 Introduction and master calendar. 00:01:03 - 00:03:10 FirstWeekDay variable. 00:03:11 - 00:04:52 BrokenWeeks variable. 00:04:53 - 00:08:34 ReferenceDay variable. Learn creating Master Calendar Part 01 : ua-cam.com/video/NLsCHsEkkQ0/v...
Qlik_074: What is Dimensionality() function in Qlik and how can we use it in practical environment.
Переглядів 2,1 тис.Рік тому
In this video, What is Dimensionality() function in Qlik and how can we use it in our practical environment. 00:00:01 - 00:00:55 Introduction of Dimensionality and Syntax of it. 00:00:56 - 00:04:40 Understanding Dimensionality in Straight Table and Pivot Table. 00:04:41 - 00:08:21 Implementing Dimensionality in Pivot table to get different colour by rows. If you want to read about Dimensionalit...
Qlik_073: How to get Metadata of all QVDs from any folder.
Переглядів 2,4 тис.Рік тому
In this video, we will see how can we load metadata of all QVDs from any folder. 00:00:01 - 00:00:55 Introduction of Metadata. 00:00:56 - 00:01:15 Create a test data QVD. 00:01:16 - 00:05:50 Get metadata of single QVD 00:05:51 - 00:25:17 Get metadata of multiple QVDs using for loop. If you want to read about QVD Metadata functions like QVDCreateTime, QVDNoOfFields, QVDNoOfRecords, QVDTableName ...
Qlik_072: How to add all columns of a Qlik Data Model table into a QS Table using an extension.
Переглядів 1,8 тис.Рік тому
In this video, we will see 1) How to create Qlik Sense Table for data analysis.. 2) How to create Qlik Sense Table using Filter Pane first. 3) How to create Qlik Sense Table using QuickTableViewer extension. 00:00:01 - 00:00:55 Introduction and create table in QlikView. 00:00:56 - 00:02:30 Create table manually in Qlik Sense using Table object. 00:02:31 - 00:03:30 Create table manually in Qlik ...
Qlik_071: How to remove leading, trailing and white spaces from a string in Qlik.
Переглядів 1,2 тис.Рік тому
In this video, we will see how to remove leading, trailing and white spaces from a string in Qlik using various string functions and MapSubString. 1) Introduction of Set verbatim = 1 2) Use of single quote while loading string. 3) Use of LTRIM(), RTRIM(), TRIM() functions. 4) Use of MapSubString. 00:00:01 - 00:03:25 Introduction of verbatim. 00:03:26 - 00:05:05 Use of LTRIM() function. 00:05:06...
Qlik_070: How Joins work in Qlik? What are the different types of Joins in Qlik.
Переглядів 2,6 тис.Рік тому
In this video, we will see 1) What is join in Qlik? Syntax and types of joins. 2) How to use it at Qlik back end and Qlik front end. 3) How to implement this function in real time project. 00:00:00 - 00:02:00 Introduction and syntax of TextBetween. 00:02:00 - 00:06:25 How Qlik associations work? 00:06:26 - 00:08:45 Inner Join 00:08:46 - 00:11:20 Left Join and Right Join 00:11:21 - 00:12:10 Full...
Qlik_069: AutoNumber02_How to use AutoNumber() function for composite keys and Link table.
Переглядів 1,6 тис.Рік тому
In this video, we will see 1) How to create composite keys and Link Table? 2) How to use AutoNumber() for composite keys? 3) How to use AutoNumber as a statement instead of function? 00:00:00 - 00:01:15 Introduction and table load. 00:01:16 - 00:02:40 Convert MonthYear field to proper datetime/date/daul format. 00:02:41 - 00:03:40 Create composite key. 00:03:41 - 00:07:30 Create link table and ...
Qlik_068: AutoNumber01_How to use AutoNumber() function in Qlik Script.
Переглядів 1,6 тис.Рік тому
In this video, we will see 1) What is AutoNumber() Function? What is the syntax of it? 2) How to use it at Qlik back end. 00:00:00 - 00:01:35 Introduction and syntax. 00:01:36 - 00:04:18 Example (using only 1st parameter) 00:04:19 - 00:08:30 Example (using 1st and 2nd parameters) If you want to read about AutoNumber() function from Qlik help help.qlik.com/en-US/sense/November2022/Subsystems/Hub...
Qlik_067: How to use TextBetween function in Qlik Script and Qlik Front End.
Переглядів 1,1 тис.Рік тому
In this video, we will see 1) What is TextBetween Function. 2) How to use it at Qlik back end and Qlik front end. 3) How to implement this function in real time project. 00:00:00 - 00:01:00 Introduction and syntax of TextBetween. 00:01:01 - 00:03:15 Example of TextBetween (Front End) 00:03:16 - 00:03:45 Example of TextBetween (Back End) 00:03:46 - 00:12:32 Practical example of TextBetween If yo...
Qlik - 066: Get cumulative and rolling total/average using As of Table (As of Calendar)
Переглядів 2,8 тис.Рік тому
In this video, we will create an As of Table (As of Calendar). Using this table, we will get rolling 3 months total, rolling 6 months total, rolling 12 months total, rolling 6 months average, cumulative total by year, non-cumulative totals. You can directly jump to relevant sections from below timeline. 1) Introduction (00:00:01 - 00:00:55) 2) What is As of Table? (00:00:56 - 00:01:55) 3) Rolli...
Qlik - 065: Cumulative Total, Cumulative Average, Rolling n-Period (Single Dimension)
Переглядів 2,4 тис.Рік тому
In this video, we will see how to get rolling 3 months total, rolling 6 months total. We will also see how to get rolling 3 months and rolling 6 months average. This total/average would work even after selecting dimensions. You can directly jump to relevant sections from below timeline. 1) Introduction (00:00:01 - 00:00:38) 2) Explanation of Rolling Total and Rolling Average (00:00:39 - 00:04:0...
Qlik - 064: Colors in Qlik Chart - 01
Переглядів 860Рік тому
In this video, we will see how to give colors to Maximum Value and Minimum Value bars in Bar Chart. Udemy Set Analysis Course www.udemy.com/course/become-an-expert-of-qlik-set-analysis/learn/lecture/9397084#overview Download material for this video from below link. drive.google.com/drive/folders/1hmPqfpwYoMkf0bankABUc6olH54vArj-?usp=sharing If you want to read about Aggregation Scope from Qlik ...
Qlik - 063 : Set_Analysis_013 : Indirect Set Analysis using P() and E() (Part 03)
Переглядів 1 тис.Рік тому
Qlik - 063 : Set_Analysis_013 : Indirect Set Analysis using P() and E() (Part 03)
Qlik - 062 : Set_Analysis_012 : Indirect Set Analysis using P() and E() (Part 02)
Переглядів 1 тис.Рік тому
Qlik - 062 : Set_Analysis_012 : Indirect Set Analysis using P() and E() (Part 02)
Qlik - 061 : Set_Analysis_011 : Indirect Set Analysis using P() and E() (Part 01)
Переглядів 1,8 тис.Рік тому
Qlik - 061 : Set_Analysis_011 : Indirect Set Analysis using P() and E() (Part 01)
Qlik - 060 : Set_Analysis_010 : Outer Set Expression (Part 02)
Переглядів 848Рік тому
Qlik - 060 : Set_Analysis_010 : Outer Set Expression (Part 02)
Qlik - 059 : Set_Analysis_010 : Outer Set Expression (Part 01)
Переглядів 1,5 тис.Рік тому
Qlik - 059 : Set_Analysis_010 : Outer Set Expression (Part 01)
Qlik - 058: Create a customized field (Calculated Dimension) in Qlik Filter using Aggr and If.
Переглядів 2,7 тис.Рік тому
Qlik - 058: Create a customized field (Calculated Dimension) in Qlik Filter using Aggr and If.
Qlik - 057: How to get Date and Time from a TimeStamp?
Переглядів 2,5 тис.Рік тому
Qlik - 057: How to get Date and Time from a TimeStamp?
Qlik - 056: Cumulative Total in Qlik using Range functions and Inter-record functions
Переглядів 3,1 тис.Рік тому
Qlik - 056: Cumulative Total in Qlik using Range functions and Inter-record functions
Qlik - 055: Range functions in Qlik : RangeSum, RangeMin, RangeMax
Переглядів 3 тис.Рік тому
Qlik - 055: Range functions in Qlik : RangeSum, RangeMin, RangeMax
Qlik - 054: Inter-record functions in Qlik : Above() and Below()
Переглядів 1,2 тис.Рік тому
Qlik - 054: Inter-record functions in Qlik : Above() and Below()
Qlik - 053: Inter-record functions in Qlik : Previous vs Peek - Part 04(Real time example)
Переглядів 958Рік тому
Qlik - 053: Inter-record functions in Qlik : Previous vs Peek - Part 04(Real time example)
Qlik - 052: Inter-record functions in Qlik : Previous vs Peek - Part 03 (real time examples)
Переглядів 1,4 тис.Рік тому
Qlik - 052: Inter-record functions in Qlik : Previous vs Peek - Part 03 (real time examples)
Qlik - 051: Inter-record functions in Qlik : Previous vs Peek - Part 02
Переглядів 1,6 тис.2 роки тому
Qlik - 051: Inter-record functions in Qlik : Previous vs Peek - Part 02
Qlik - 050: Inter-record functions in Qlik : Previous vs Peek - Part 01
Переглядів 2 тис.2 роки тому
Qlik - 050: Inter-record functions in Qlik : Previous vs Peek - Part 01
Qlik - 049: Interpretation functions vs Formatting functions in Qlik. Date vs Date# (Part 02)
Переглядів 9742 роки тому
Qlik - 049: Interpretation functions vs Formatting functions in Qlik. Date vs Date# (Part 02)

КОМЕНТАРІ

  • @bhargavireddychavva6280
    @bhargavireddychavva6280 6 днів тому

    Please make a video on how incremental load works without primary key

  • @bhargavireddychavva6280
    @bhargavireddychavva6280 7 днів тому

    Very well explained.. how can we achieve if we don’t know the qvd exists or not please explain

  • @SravanKumarReddy-n3x
    @SravanKumarReddy-n3x 10 днів тому

    Thank You Manish, Really i understand in a very better way about the concepts which you explained.

  • @SravanKumarReddy-n3x
    @SravanKumarReddy-n3x 13 днів тому

    What a detailed explanation really you are giving, Since i have experienced in qlik sense but when i saw your videos am asking my self do i really know the qlik. Learning a lot. Heartfully thanks for uploading the videos.

  • @wissawattaesuji
    @wissawattaesuji 15 днів тому

    🙏❤️

  • @bigbrainwithabb1606
    @bigbrainwithabb1606 18 днів тому

    Amazing to see such a clear, structured and well explained video. 👍Its so helpful!!

  • @wissawattaesuji
    @wissawattaesuji 24 дні тому

    😊🙏

  • @rushalibhand4944
    @rushalibhand4944 24 дні тому

    Hello Manish, can we convert a measure into dimension using aggr function ? I have a nested if condition where i am calculating a measure which is represented as a text in the front end in the table as ‘Yes’ or ‘No’. I would want to use it in the filter to see yes and no both. Is it possible?

  • @KeyBorg1
    @KeyBorg1 25 днів тому

    If you use Exists(OrderID) but OrderID is not in the LOAD statement, is it not optimized. This one has caught me more than once!

  • @kartiksemwal1391
    @kartiksemwal1391 26 днів тому

    Hi Manish Sir, if we don't want to use calculated dimension and need to do this in the backend. So, when we are doing group by based on Brand. If we add Category and Country in the group by then it should work, right? I'm not able to download the data I guess it is expired.....

  • @bollavinod4051
    @bollavinod4051 27 днів тому

    Really superb

  • @devendrakhamkar2941
    @devendrakhamkar2941 Місяць тому

    Please create a video on Sheet level access using section access

  • @AnkitPandey-ju1ff
    @AnkitPandey-ju1ff Місяць тому

    Please drop more videos on QMC

  • @AnkitPandey-ju1ff
    @AnkitPandey-ju1ff Місяць тому

    Please drop more videos with such a good information

  • @sanketdhakare1082
    @sanketdhakare1082 Місяць тому

    Thank you for the Knowlege, Cant we use the interval match function here?

  • @SurendraNandi-pv4mq
    @SurendraNandi-pv4mq Місяць тому

    Hi Manish sir, I need help here. After selecting anyone of the bucket. The countries selection are appearing. Instead of can we display bucket selected range in selection bar?

  • @user-mo4vu5sw5u
    @user-mo4vu5sw5u Місяць тому

    Thank you Sir for this excellent learning video. And, quick question, when referencing the loop counter Var in the Peek fx of the For Loop Exercise (around 16:19), I have noticed the var works with or without being expanded? How is it so...& what is the best practice? Thank you

  • @nicholaspetre1
    @nicholaspetre1 2 місяці тому

    Thanks! It's a good one!

  • @maneeshbuddha8253
    @maneeshbuddha8253 2 місяці тому

    for last five videos there is no Audio for the video.

  • @saikatchatterjee2100
    @saikatchatterjee2100 2 місяці тому

    Nicely Explained , Thank you.

  • @Robert8455
    @Robert8455 2 місяці тому

    Excellent. As always Manish, you have explained it very clearly and simple.

  • @BonJunCuevas
    @BonJunCuevas 3 місяці тому

    Thank you👍🏻

  • @chodipilliravikumar4459
    @chodipilliravikumar4459 3 місяці тому

    Please send data file

  • @samkaran6351
    @samkaran6351 3 місяці тому

    Hi , small doubt how the where not exist works here ? We don't need to Concatenate the currency with date right ibviously that combination doesn't exist right and it should not eliminate the duplicate right I.e. we are comparing 01.07.2023 - 1.21 with 01.07.2023 - - how come this is eliminating the duplicate

  • @Robert8455
    @Robert8455 4 місяці тому

    Very powerful, highly useful and well explained. This is the case with all of your videos. You are a gifted teacher and presenter and I totally appreciate the succinctness of your efforts.

  • @Robert8455
    @Robert8455 4 місяці тому

    Very slick! Thanks Manish

  • @crownambassador1
    @crownambassador1 4 місяці тому

    Is this the efficient optimized way of loading combinations dynamically shown in this video ? OR using for each value ( cross join method ) showing in Video 7 / 8 ?

  • @crownambassador1
    @crownambassador1 4 місяці тому

    Ideally this scenario of Concatenate and then using Where not Exists - This should be tackled in the security table in the database that should be kept up-to-date. Then there is no need to do concatenate and where not exists. Let me know what do you think.

  • @sirinaydin8786
    @sirinaydin8786 4 місяці тому

    Amazing content! Thanks man!

  • @emilianoalvarez3412
    @emilianoalvarez3412 4 місяці тому

    Thank you very much for your videos. They are really useful. Greetings from Argentina.

  • @rafiusk22
    @rafiusk22 4 місяці тому

    Is the difference between using * and ALL just that ALL sees everything and * only what's in SA?

  • @Madina_analyst_support
    @Madina_analyst_support 4 місяці тому

    Thank you for your lessons, they helped me a lot.

  • @user-uv1gy9zy3j
    @user-uv1gy9zy3j 4 місяці тому

    Excellent. Nice work!

  • @user-fk7if3ho5h
    @user-fk7if3ho5h 4 місяці тому

    Good explanation. Better than Udemy courses!

  • @franktheisohn1414
    @franktheisohn1414 4 місяці тому

    Very nice, structured and understandable Tutorial! Thank you - that helps a lot

  • @zsofiaszlanka9371
    @zsofiaszlanka9371 4 місяці тому

    One of the best Qlik Video I have ever seen.Many thanks

  • @user-bu6vb8vv7g
    @user-bu6vb8vv7g 4 місяці тому

    Hi Manish, Great video. The columns work well but in my case I would need o add the sum in the qlik script of the backend and not as measure. Do you know how I can do that? Thanks!

  • @rafiusk22
    @rafiusk22 5 місяців тому

    Thanks for your videos

  • @rafiusk22
    @rafiusk22 5 місяців тому

    Excellent.

  • @rafiusk22
    @rafiusk22 5 місяців тому

    Congratulations, very well explained and detailed video. Thank you very much for the video. Keep producing more content like this.

  • @Robert8455
    @Robert8455 5 місяців тому

    Good explanation!

  • @sameerulhaq4066
    @sameerulhaq4066 5 місяців тому

    what if I want to do with Year and I have two tables containing two dates with different name but I want to link them based on the year

  • @deepankan03
    @deepankan03 5 місяців тому

    Amazing

  • @AfreenSyed-rl1xf
    @AfreenSyed-rl1xf 5 місяців тому

    Thank you so much

  • @muralisaiganeshchiranji8081
    @muralisaiganeshchiranji8081 5 місяців тому

    Hi Manish Thanks for you explanation but I have small doubt When you created the %key_Field2, you have created in only one table but not in the second table which you are concatenating Is it not required to create a %key_Field2 column in the second table ?

  • @kartiksemwal1391
    @kartiksemwal1391 6 місяців тому

    Hi Manish Sir, it is very helpful video thank you so much… What if we want to get bottom 5 and we have identical values in data. Then how will we identify and do the ranking?

  • @prudhviteja9263
    @prudhviteja9263 6 місяців тому

    what if you want to see data of rolling 12 months but from months starting jan 2021 in dimension it starts showing 15,558 instead of 230314. So, how you solve this?

  • @deepankan03
    @deepankan03 6 місяців тому

    Amazing

  • @NilkanthPanigrahi
    @NilkanthPanigrahi 6 місяців тому

    Any channel recommendation for Qlik QMC related stuff??

  • @deepankan03
    @deepankan03 6 місяців тому

    amazing