Qlik2Express Biswadeep Moitra
Qlik2Express Biswadeep Moitra
  • 54
  • 381 784
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: ua-cam.com/video/RN-xRgP0oL4/v-deo.html
Please follow me on:
LinkedIn: linkedin.com/in/biswadeep-moitra-98137079
Gmail: qlik2express@gmail.com
Facebook: biswadeep.moitra
Instagram: biswadeep_moitra
Переглядів: 4 869

Відео

34. b) Interval Match Qlik Sense Part-2
Переглядів 3,3 тис.3 роки тому
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
Переглядів 7 тис.3 роки тому
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,6 тис.3 роки тому
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)
Переглядів 9 тис.4 роки тому
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,2 тис.4 роки тому
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: ua-cam.com/video/RN-xRgP0oL4/v-deo.html Please follow me on: LinkedIn: linkedin.com/in/biswadeep-moitra-981370...
31. a) Master Items Part 1
Переглядів 1,7 тис.4 роки тому
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,5 тис.4 роки тому
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
Переглядів 12 тис.4 роки тому
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
Переглядів 6 тис.5 років тому
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
Переглядів 5 тис.5 років тому
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
Переглядів 11 тис.5 років тому
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: ua-cam.com/video/RN-xRgP0oL4/v-deo.html Please follow me on: LinkedIn: linkedin.com/in/biswadeep-moitra-98137079 Gmail: qlik2express@gmail....
25. b) Loop Part 2: Do While
Переглядів 3,3 тис.5 років тому
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: ua-cam.com/video/RN-xRgP0oL4/v-deo.html Please follow me on: LinkedIn: linkedin.com/in/biswadeep-moitra-98137079 Gmail...
25. a) Loop Part 1: For Loop in Qlik Sense
Переглядів 8 тис.5 років тому
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: ua-cam.com/video/RN-xRgP0oL4/v-deo.html Please follow me on: LinkedIn: linkedin.com/in/biswadeep-moitra-98137079 Gmail: qlik2express@gmail.com Facebook: biswadeep.moitra Instagram: inst...
24. Set Analysis in Qlik Sense
Переглядів 9 тис.5 років тому
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: ua-cam.com/video/RN-xRgP0oL4/v-deo.html Please follow me on: LinkedIn: linkedin.com/in/biswadee...
23. If Statement in Qlik Sense
Переглядів 10 тис.5 років тому
23. If Statement in Qlik Sense
19. Aggr Function & Range Sum function in Qlik Sense
Переглядів 19 тис.5 років тому
19. Aggr Function & Range Sum function in Qlik Sense
18. e) Charts Part 5: Gauge Chart in Qlik Sense
Переглядів 2,9 тис.5 років тому
18. e) Charts Part 5: Gauge Chart in Qlik Sense
18. d) Charts Part 4: Basic Properties in Charts in Qlik Sense
Переглядів 1,6 тис.5 років тому
18. d) Charts Part 4: Basic Properties in Charts in Qlik Sense
18. c) Charts Part 3: Waterfall Chart in Qlik Sense
Переглядів 2,7 тис.5 років тому
18. c) Charts Part 3: Waterfall Chart in Qlik Sense
18. b) Charts Part 2: Tree Map, Distribution,Histogram in Qlik Sense
Переглядів 1,8 тис.5 років тому
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,9 тис.5 років тому
18. a) Charts Part 1: Bar, line, Combo, Pi, Scatter, Box Plot in Qlik Sense
27. Master Calendar in Qlik Sense
Переглядів 12 тис.5 років тому
27. Master Calendar in Qlik Sense
21. Peek( ) and Previous ( ) functions in qlik sense
Переглядів 11 тис.5 років тому
21. Peek( ) and Previous ( ) functions in qlik sense
25b Loop Part 2 Do While
Переглядів 875 років тому
25b Loop Part 2 Do While
18. d) Charts Part 4: Basic Properties of charts in qlik sense
Переглядів 1075 років тому
18. d) Charts Part 4: Basic Properties of charts in qlik sense
19. Aggr Function & Range Sum
Переглядів 3135 років тому
19. Aggr Function & Range Sum
23 If Statement
Переглядів 1425 років тому
23 If Statement
22. Pick ( ) & Match( ) in Qlik Sense
Переглядів 11 тис.5 років тому
22. Pick ( ) & Match( ) in Qlik Sense
15. a) Apply Map ( ) in Qlik Sense
Переглядів 17 тис.5 років тому
15. a) Apply Map ( ) in Qlik Sense

КОМЕНТАРІ

  • @kabeer0701
    @kabeer0701 11 днів тому

    If we want to add column which says format

  • @kabeer0701
    @kabeer0701 12 днів тому

    Do you provide classes?

  • @kabeer0701
    @kabeer0701 12 днів тому

    Do you provide classes?

  • @shreyadeo315
    @shreyadeo315 28 днів тому

    Where is the excel files that you're using in the videos. Please provide that as well, so we can follow along

  • @swarnapavani-2305
    @swarnapavani-2305 Місяць тому

    Super sir

  • @ChaunceyLarabel-d2o
    @ChaunceyLarabel-d2o 2 місяці тому

    Carson Plain

  • @DaisyGloria-n6v
    @DaisyGloria-n6v 2 місяці тому

    114 Borer Manors

  • @LindaBritt-q8l
    @LindaBritt-q8l 2 місяці тому

    Dawson Fords

  • @WarrenMorton-g8c
    @WarrenMorton-g8c 2 місяці тому

    005 Itzel Locks

  • @GaryWilliams-r8k
    @GaryWilliams-r8k 2 місяці тому

    Delphine Well

  • @PhilipLamb-g7p
    @PhilipLamb-g7p 2 місяці тому

    Hirthe Lane

  • @ElijahMorphis-m5k
    @ElijahMorphis-m5k 3 місяці тому

    Zboncak Court

  • @LazaroAngione-q8d
    @LazaroAngione-q8d 3 місяці тому

    Hollie Canyon

  • @DeweyPayne-t8i
    @DeweyPayne-t8i 3 місяці тому

    Klein Islands

  • @JannChastant-f8v
    @JannChastant-f8v 3 місяці тому

    Reilly Points

  • @TimothyGonzalez-e7n
    @TimothyGonzalez-e7n 3 місяці тому

    Walter Corners

  • @MaryLopez-h6l
    @MaryLopez-h6l 3 місяці тому

    Macejkovic Street

  • @MatthewRodriguez-y6h
    @MatthewRodriguez-y6h 3 місяці тому

    Kaleb Cape

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

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

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

    Heyy I need the dataset?

  • @TechRushi-b1g
    @TechRushi-b1g 5 місяців тому

    Any crack version is available of qliksense?

  • @TechRushi-b1g
    @TechRushi-b1g 5 місяців тому

    This is free?

  • @samkaran6351
    @samkaran6351 9 місяців тому

    What is the use of qualify

  • @samkaran6351
    @samkaran6351 9 місяців тому

    What is the use of this

  • @samkaran6351
    @samkaran6351 9 місяців тому

    Good, please avoid back ground noice

  • @samkaran6351
    @samkaran6351 9 місяців тому

    Lot of background noise

  • @samkaran6351
    @samkaran6351 9 місяців тому

    Cool, easy to understand

  • @samkaran6351
    @samkaran6351 9 місяців тому

    Is this only available in qliksense desktop

  • @uddeshdharmik8168
    @uddeshdharmik8168 Рік тому

    can we make 1st selection bydefault?

  • @ivansanczuk2641
    @ivansanczuk2641 Рік тому

    genio

  • @jenilsaliya3769
    @jenilsaliya3769 Рік тому

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

  • @sonamrani6501
    @sonamrani6501 Рік тому

    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 2 роки тому

    Nice Explanation, could please share your number

  • @shaikalisher2164
    @shaikalisher2164 2 роки тому

    Very simple and nice explanation, really appreciate the work.