Qlik2Express Biswadeep Moitra
Qlik2Express Biswadeep Moitra
  • 54
  • 372 456
35. YTD MTD in Qlik
YTD Stand for Year to date means, 'required calculated-data' falls in the bucket of 01-January of selected/latest Year to max-selelected/ latest date
MTD Stands for Month to date means, 'required calculated-data' falls in the bucket of 01 of selected/latest month to max-selelected/ latest date
Prequisite Points
1. Set Analysis
2. Addyears(), today(), Yearstart() functions
For more videos please visit: th-cam.com/video/RN-xRgP0oL4/w-d-xo.html
Please follow me on:
LinkedIn: linkedin.com/in/biswadeep-moitra-98137079
Gmail: qlik2express@gmail.com
Facebook: biswadeep.moitra
Instagram: biswadeep_moitra
มุมมอง: 4 649

วีดีโอ

34. b) Interval Match Qlik Sense Part-2
มุมมอง 3.2K3 ปีที่แล้ว
The IntervalMatch( ) prefix function used to create a table matching 'discrete' numeric/ date/ time values to one or more numeric/ date/ time intervals respectively IntervalMatch is one such case where we use synthetic key to make a association between two tables. Important points in IntervalMatch 1. Must have a good understanding of data 2. Must be discrete data 3. The two table tables has no ...
34. a) IntervalMatch Qlik Sense Part-1
มุมมอง 7K3 ปีที่แล้ว
The IntervalMatch( ) prefix function used to create a table matching 'discrete' numeric/ date/ time values to one or more numeric/ date/ time intervals respectively IntervalMatch is one such case where we use synthetic key to make a association between two tables. Important points in IntervalMatch 1. Must have a good understanding of data 2. Must be discrete data 3. The two table tables has no ...
33. Cross Tables
มุมมอง 2.6K3 ปีที่แล้ว
Hello Everyone, in this video we will be discussing on Cross Table Defination: The crosstable function is used to turn a cross table into a straight table, that is, a wide table with many columns is turned into a table, with the column headings being placed into a single attribute column. Syntax: crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement ) Lin...
32. Container in Qlik Sense (Hide or Show an Object)
มุมมอง 8K3 ปีที่แล้ว
Hi, Here we will be discussing on container in qlik sense. Container: It is an object winch is used to contain/keep multiple object in a single box. This will help in keeping multiple object in small space. Also help in hide/show an object based on condition. Link: For Document: drive.google.com/file/d/1n_O2rETEd4jDkK7i0UVHIz2zJt9E735O/view?usp=sharing Note: (Document is for briefs, not for the...
31. b) Master Items Part 2 (Changing Colors of Charts & Drill-Down)
มุมมอง 1.1K3 ปีที่แล้ว
Hi, In this video will tell you how to create a drilldown and give color based on your requirement. ink: For Document: drive.google.com/file/d/1n_O2rETEd4jDkK7i0UVHIz2zJt9E735O/view?usp=sharing Note: (Document is for briefs, not for the detail description) For more videos please visit: th-cam.com/video/RN-xRgP0oL4/w-d-xo.html Please follow me on: LinkedIn: linkedin.com/in/biswadeep-moitra-98137...
31. a) Master Items Part 1
มุมมอง 1.7K3 ปีที่แล้ว
Hi Everyone, In this video we will be discussing on Master Items Definition: It is a self-service environment allows the developer to create a set of predefined and reusable measures, dimensions, and visualizations. It is reusable, that means it can be used in different sheets or multiple times in an app. All these charts are interlinked, that means change in one chart/measure/dimension will re...
30 b) Incremental load part 2
มุมมอง 4.5K4 ปีที่แล้ว
Hello Everyone, Hope you guys are doing well. Stay safe. This video will walk you through the incremental load in Qlik Sense. This is part-2 of incremental Load. Definition: Loading the new /updated records without loading the full data is called Incremental load. Points to remember: Here we will be doing Insert-Update-Delete Step1: Load the data and store in in the QVD Step2: Find the number o...
30. a) Incremental load part 1
มุมมอง 12K4 ปีที่แล้ว
Hello Everyone, Hope you guys are doing well. Stay safe. This video will walk you through the incremental load in Qlik Sense. This is part-1 of incremental Load. Definition: Loading the new /updated records without loading the full data is called Incremental load. Points to remember: 1. There are two QVDs a) Full QVF: Which runs ones in gap so as to load the full data including the historical d...
29. Where and Where Exist Condition
มุมมอง 6K5 ปีที่แล้ว
Hello everyone, In this tutorial we will be discussing on Where and where Exist condition. Where condition it is used to put a condition/filter in the data load Exists It is used to compare a set of column and if the data matches then it will load that respective data Link: For Document: drive.google.com/file/d/1n_O2rETEd4jDkK7i0UVHIz2zJt9E735O/view?usp=sharing Note: (Document is for briefs, no...
28. Bookmarks, Snapshots and Stories in Qlik Sense
มุมมอง 4.9K5 ปีที่แล้ว
Hi, we all be discussing on Bookmarks, Snapshots and Stories in Qlik Sense. The purpose of a story creation is to gather insight and build narratives from the data you have created in the application. Bookmarks keep you selections handy so that you don't have to make the same selection again and again. Snapshots are the stills of charts/tables you would have created in your app. Link: For Docum...
26. Drill Down and Master items in Qlik Sense
มุมมอง 11K5 ปีที่แล้ว
Hi Friends here we will be discussing on Drill Down and Master items. Link: For Document: drive.google.com/file/d/1n_O2rETEd4jDkK7i0UVHIz2zJt9E735O/view?usp=sharing Note: (Document is for briefs, not for the detail description) For more videos please visit: th-cam.com/video/RN-xRgP0oL4/w-d-xo.html Please follow me on: LinkedIn: linkedin.com/in/biswadeep-moitra-98137079 Gmail: qlik2express@gmail...
25. b) Loop Part 2: Do While
มุมมอง 3.2K5 ปีที่แล้ว
Hi Friends here we will be discussing on 'do while loop' or 'while loop' in qlik sense Link: For the Document: drive.google.com/file/d/1n_O2rETEd4jDkK7i0UVHIz2zJt9E735O/view?usp=sharing Note: (Document is for briefs, not for the detail description) For more videos please visit: th-cam.com/video/RN-xRgP0oL4/w-d-xo.html Please follow me on: LinkedIn: linkedin.com/in/biswadeep-moitra-98137079 Gmai...
25. a) Loop Part 1: For Loop in Qlik Sense
มุมมอง 8K5 ปีที่แล้ว
Hi All, we will be discussing foor loop in qlik sense Loops in Qlik Sense FOR NEXT : Use a counter to loop over statements. Syntax : FOR i = 1 TO 10 Load the table NEXT For more videos please visit: th-cam.com/video/RN-xRgP0oL4/w-d-xo.html Please follow me on: LinkedIn: linkedin.com/in/biswadeep-moitra-98137079 Gmail: qlik2express@gmail.com Facebook: biswadeep.moitra Instagram: ins...
24. Set Analysis in Qlik Sense
มุมมอง 9K5 ปีที่แล้ว
Set expressions aggregate values for the current set of selections. The groups sets of if conditions together Link: For the Document: drive.google.com/file/d/1n_O2rETEd4jDkK7i0UVHIz2zJt9E735O/view?usp=sharing Note: (Document is for briefs, not for the detail description) For more videos please visit: th-cam.com/video/RN-xRgP0oL4/w-d-xo.html Please follow me on: LinkedIn: linkedin.com/in/biswade...
23. If Statement in Qlik Sense
มุมมอง 10K5 ปีที่แล้ว
23. If Statement in Qlik Sense
19. Aggr Function & Range Sum function in Qlik Sense
มุมมอง 18K5 ปีที่แล้ว
19. Aggr Function & Range Sum function in Qlik Sense
18. e) Charts Part 5: Gauge Chart in Qlik Sense
มุมมอง 2.8K5 ปีที่แล้ว
18. e) Charts Part 5: Gauge Chart in Qlik Sense
18. d) Charts Part 4: Basic Properties in Charts in Qlik Sense
มุมมอง 1.5K5 ปีที่แล้ว
18. d) Charts Part 4: Basic Properties in Charts in Qlik Sense
18. c) Charts Part 3: Waterfall Chart in Qlik Sense
มุมมอง 2.6K5 ปีที่แล้ว
18. c) Charts Part 3: Waterfall Chart in Qlik Sense
18. b) Charts Part 2: Tree Map, Distribution,Histogram in Qlik Sense
มุมมอง 1.7K5 ปีที่แล้ว
18. b) Charts Part 2: Tree Map, Distribution,Histogram in Qlik Sense
18. a) Charts Part 1: Bar, line, Combo, Pi, Scatter, Box Plot in Qlik Sense
มุมมอง 2.9K5 ปีที่แล้ว
18. a) Charts Part 1: Bar, line, Combo, Pi, Scatter, Box Plot in Qlik Sense
27. Master Calendar in Qlik Sense
มุมมอง 12K5 ปีที่แล้ว
27. Master Calendar in Qlik Sense
21. Peek( ) and Previous ( ) functions in qlik sense
มุมมอง 11K5 ปีที่แล้ว
21. Peek( ) and Previous ( ) functions in qlik sense
25b Loop Part 2 Do While
มุมมอง 865 ปีที่แล้ว
25b Loop Part 2 Do While
18. d) Charts Part 4: Basic Properties of charts in qlik sense
มุมมอง 1035 ปีที่แล้ว
18. d) Charts Part 4: Basic Properties of charts in qlik sense
19. Aggr Function & Range Sum
มุมมอง 3115 ปีที่แล้ว
19. Aggr Function & Range Sum
23 If Statement
มุมมอง 1425 ปีที่แล้ว
23 If Statement
22. Pick ( ) & Match( ) in Qlik Sense
มุมมอง 10K5 ปีที่แล้ว
22. Pick ( ) & Match( ) in Qlik Sense
15. a) Apply Map ( ) in Qlik Sense
มุมมอง 17K5 ปีที่แล้ว
15. a) Apply Map ( ) in Qlik Sense

ความคิดเห็น

  • @PhilipLamb-g7p
    @PhilipLamb-g7p 25 นาทีที่ผ่านมา

    Hirthe Lane

  • @ElijahMorphis-m5k
    @ElijahMorphis-m5k 5 วันที่ผ่านมา

    Zboncak Court

  • @LazaroAngione-q8d
    @LazaroAngione-q8d 8 วันที่ผ่านมา

    Hollie Canyon

  • @DeweyPayne-t8i
    @DeweyPayne-t8i 14 วันที่ผ่านมา

    Klein Islands

  • @JannChastant-f8v
    @JannChastant-f8v 14 วันที่ผ่านมา

    Reilly Points

  • @TimothyGonzalez-e7n
    @TimothyGonzalez-e7n 15 วันที่ผ่านมา

    Walter Corners

  • @MaryLopez-h6l
    @MaryLopez-h6l 17 วันที่ผ่านมา

    Macejkovic Street

  • @MatthewRodriguez-y6h
    @MatthewRodriguez-y6h 18 วันที่ผ่านมา

    Kaleb Cape

  • @mukulrampal6255
    @mukulrampal6255 หลายเดือนก่อน

    but , when you reload it is taking full load only with 7 records

  • @nikitabadgujar6996
    @nikitabadgujar6996 2 หลายเดือนก่อน

    Heyy I need the dataset?

  • @TechRushi-b1g
    @TechRushi-b1g 2 หลายเดือนก่อน

    Any crack version is available of qliksense?

  • @TechRushi-b1g
    @TechRushi-b1g 2 หลายเดือนก่อน

    This is free?

  • @samkaran6351
    @samkaran6351 6 หลายเดือนก่อน

    What is the use of qualify

  • @samkaran6351
    @samkaran6351 6 หลายเดือนก่อน

    What is the use of this

  • @samkaran6351
    @samkaran6351 7 หลายเดือนก่อน

    Good, please avoid back ground noice

  • @samkaran6351
    @samkaran6351 7 หลายเดือนก่อน

    Lot of background noise

  • @samkaran6351
    @samkaran6351 7 หลายเดือนก่อน

    Cool, easy to understand

  • @samkaran6351
    @samkaran6351 7 หลายเดือนก่อน

    Is this only available in qliksense desktop

    • @qlik2expressbiswadeepmoitr305
      @qlik2expressbiswadeepmoitr305 7 หลายเดือนก่อน

      If you ask the terminology then 'yes' But ideally all the data model is basically this

  • @uddeshdharmik8168
    @uddeshdharmik8168 10 หลายเดือนก่อน

    can we make 1st selection bydefault?

  • @ivansanczuk2641
    @ivansanczuk2641 10 หลายเดือนก่อน

    genio

  • @jenilsaliya3769
    @jenilsaliya3769 11 หลายเดือนก่อน

    why you have upted v at the start of variable name / is this syntex or just convention

  • @sonamrani6501
    @sonamrani6501 11 หลายเดือนก่อน

    Sir, can you please give us interview questions of QlikView /Qlik Sense

  • @PochinkiVeteran
    @PochinkiVeteran ปีที่แล้ว

    Great explanation ❤

  • @boorhanrashid6985
    @boorhanrashid6985 ปีที่แล้ว

    In this case if I want to have two charts - Line and Table, both having the drill down dimensions in it, provide a custom list of colors for different values in each level of drill down for example - At Country level we have red, Green, Blue for 3 countries and then for states also use the same order of colors so red and green for two states if present. I then want this order of picking colors to remain constant for any other visualisation. How can I do this?

  • @sujatarao9913
    @sujatarao9913 ปีที่แล้ว

    What if we do the incremental load and transforming the data , we would not like to transform the whole data again , how to apply the transformation in only incremental part ?

  • @Shivamkumar-vj4rt
    @Shivamkumar-vj4rt ปีที่แล้ว

    Really Sir, these are remarkable content, and I have successfully completed it, one thing i want to know, i am preparing for Genpact , and qlik sense is going to asked in qliksense, so is that enough or should i have to read more

  • @ssss8853
    @ssss8853 ปีที่แล้ว

    woww

  • @ssss8853
    @ssss8853 ปีที่แล้ว

    confusing

  • @ssss8853
    @ssss8853 ปีที่แล้ว

    average explanation not clear

  • @Davidgon100
    @Davidgon100 ปีที่แล้ว

    Thanks Biswadeep

  • @NavyaSharma-s1l
    @NavyaSharma-s1l ปีที่แล้ว

    this is not insert and update case it only contains insert case

  • @suresh555v
    @suresh555v ปีที่แล้ว

    Your tutorial is very interesting ... Can you pls make video on NPrinting and QMC?

  • @sd.mastanvvali2862
    @sd.mastanvvali2862 ปีที่แล้ว

    Thanks so much for making this video's. these are so helpful me for my practising.👍👍👍

  • @JaheedMd-ro3jd
    @JaheedMd-ro3jd ปีที่แล้ว

    What is the use of information density in a data model. I know the definitions

  • @niroshab5328
    @niroshab5328 ปีที่แล้ว

    have yu shared that excel document anywhere?

  • @gczz
    @gczz ปีที่แล้ว

    In my mind, SUM(AGGR(MAX(Salary),City)) is showing the same as MAX(Salary) if you have a City as dimension (as is your case).

  • @NoOne-tp7oe
    @NoOne-tp7oe ปีที่แล้ว

    pls make video on how to create fiscal calender

  • @ゼロゼロ-d8x
    @ゼロゼロ-d8x ปีที่แล้ว

    Hi sir, do I have to change the expression's syntax if I don't use variables to define the YTD ?

  • @shaikalisher2164
    @shaikalisher2164 ปีที่แล้ว

    Nice Explanation, could please share your number

  • @shaikalisher2164
    @shaikalisher2164 ปีที่แล้ว

    Very simple and nice explanation, really appreciate the work.

  • @bidhanry9740
    @bidhanry9740 ปีที่แล้ว

    I am writing this comment in an hope to get a reply... Sir is possible to change chart type while drill down, suppose I have a bar chart, upon selecting a particular bar, the drill down will occur, and it shows a stack bar chart?

    • @qlik2expressbiswadeepmoitr305
      @qlik2expressbiswadeepmoitr305 ปีที่แล้ว

      Hi. Yes it's possible, use a container and hide and show chart based on getselectcount () function

  • @ushakumari8474
    @ushakumari8474 ปีที่แล้ว

    Thanks :)

  • @khizer490
    @khizer490 ปีที่แล้ว

    thankyou so much bro your explaining very well

  • @Ani-rm8mm
    @Ani-rm8mm ปีที่แล้ว

    Really good explanation, thank you!

  • @sathwik98
    @sathwik98 ปีที่แล้ว

    This video is actually confusing. There is a lag between your voice and the screen recording. There is no sync

  • @SachinKumar-lk8gx
    @SachinKumar-lk8gx 2 ปีที่แล้ว

    May you provide dimension and fact table data link

  • @sathwik98
    @sathwik98 2 ปีที่แล้ว

    But creating for each and every sem will be hectic, is there any other way

  • @sathwik98
    @sathwik98 2 ปีที่แล้ว

    Wish we have the data sets also to practise it along with you

  • @sathwik98
    @sathwik98 2 ปีที่แล้ว

    Your videos are really helping me mastering the qliksense. It is really useful. The fundamentals are really strong

  • @gamechanger7917
    @gamechanger7917 2 ปีที่แล้ว

    Good videos sir