- 54
- 380 451
Qlik2Express Biswadeep Moitra
India
เข้าร่วมเมื่อ 4 เม.ย. 2019
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
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 842
วีดีโอ
34. b) Interval Match Qlik Sense Part-2
มุมมอง 3.3K3 ปีที่แล้ว
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)
มุมมอง 9K4 ปีที่แล้ว
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.2K4 ปีที่แล้ว
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.7K4 ปีที่แล้ว
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
มุมมอง 5K5 ปีที่แล้ว
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.3K5 ปีที่แล้ว
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...
19. Aggr Function & Range Sum function in Qlik Sense
มุมมอง 19K5 ปีที่แล้ว
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.6K5 ปีที่แล้ว
18. d) Charts Part 4: Basic Properties in Charts in Qlik Sense
18. c) Charts Part 3: Waterfall Chart in Qlik Sense
มุมมอง 2.7K5 ปีที่แล้ว
18. c) Charts Part 3: Waterfall Chart in Qlik Sense
18. b) Charts Part 2: Tree Map, Distribution,Histogram in Qlik Sense
มุมมอง 1.8K5 ปีที่แล้ว
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
21. Peek( ) and Previous ( ) functions in qlik sense
มุมมอง 11K5 ปีที่แล้ว
21. Peek( ) and Previous ( ) functions in qlik sense
18. d) Charts Part 4: Basic Properties of charts in qlik sense
มุมมอง 1055 ปีที่แล้ว
18. d) Charts Part 4: Basic Properties of charts in qlik sense
Where is the excel files that you're using in the videos. Please provide that as well, so we can follow along
Super sir
Carson Plain
114 Borer Manors
Dawson Fords
005 Itzel Locks
Delphine Well
Hirthe Lane
Zboncak Court
Hollie Canyon
Klein Islands
Reilly Points
Walter Corners
Macejkovic Street
Kaleb Cape
but , when you reload it is taking full load only with 7 records
Heyy I need the dataset?
Any crack version is available of qliksense?
This is free?
What is the use of qualify
To create dataenodel, remove synthetic keys
What is the use of this
Good, please avoid back ground noice
Lot of background noise
Cool, easy to understand
Is this only available in qliksense desktop
If you ask the terminology then 'yes' But ideally all the data model is basically this
can we make 1st selection bydefault?
Yes, use default bookmark
genio
why you have upted v at the start of variable name / is this syntex or just convention
Sir, can you please give us interview questions of QlikView /Qlik Sense
Great explanation ❤
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?
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 ?
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
The content here is sufficient upto 3 years experience
woww
confusing
average explanation not clear
Thanks Biswadeep
this is not insert and update case it only contains insert case
Your tutorial is very interesting ... Can you pls make video on NPrinting and QMC?
Thanks so much for making this video's. these are so helpful me for my practising.👍👍👍
What is the use of information density in a data model. I know the definitions
have yu shared that excel document anywhere?
The Excel has been made adhoc basis
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).
True, one result can be achieved by multiple ways
pls make video on how to create fiscal calender
Hi sir, do I have to change the expression's syntax if I don't use variables to define the YTD ?
Nice Explanation, could please share your number
Very simple and nice explanation, really appreciate the work.
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?
Hi. Yes it's possible, use a container and hide and show chart based on getselectcount () function
Thanks :)
thankyou so much bro your explaining very well