QlikView Tutorial | Creating Master Calendar in QlikView | Data & Tools

Подписаться 69 тыс.

Просмотров 22 тыс.

50% 1

In this Data & Tools QlikView video I've talked about how you can create master calendar in qlikview which is important for doing the right selection as well as for other activities like creating fiscal calendar etc.
Please find below the spreadsheet link where I've copied the data that is used in the example as well as the script to create master calender.
how to get most recent year and month value,company specific calendar in qlikview,Master Calendar in QlikView,how to create master calendar in qlikview,what is master calendar in qlikview,QlikView,Data & Tools,Qlikview by Abhishek,qlikview master calendar,master calendar qlikview,master calendar in qlikview script,creating a master calendar in qlikview,creating master calendar in qlikview,how to use master calendar in qlikview,calendar creation in qlikview
Excel file - drive.google.c...
Also if you want to view other videos by searching it, then please visit document below which contains the list of all the uploads so far.
drive.google.c...
Also here is a list of some other related videos -
How to create Search object in QlikView - • QlikView Tutorial | Ql...
How to search in QlikView - • QlikView Tutorial | Ql...
How to create Containers in QlikView - • QlikView Tutorial | Ql...
How to view QlikView Object in Microsoft Excel - • QlikView Tutorial | Ql...
How to import cross table in QlikView - • QlikView Tutorial | Im...
How create PDF reports in QlikView - • How to create Static/P...
How to create bar chart in QlikView - • QlikView Charting | Cr...
How to create Line Chart in QlikView - • QlikView | Line Chart ...
How to interchange Bar Chart and Line Chart in QlikView - • QlikView Tutorial | Ql...
How to create combo chart in QlikView - • QlikView | How to Crea...
How to create Radar Chart in QlikView - • QlikView Tutorial | Ql...
How to create staked bar chart in QlikView - • QlikView Tutorials | S...
How to create Block Chart in QlikView - • QlikView Tutorial | Ql...
How to create Pie chart in QlikView - • QlikView Tutorials | Q...
How to create Step Line Chart in QlikView - • QlikView Tutorial | Ql...
How to create waterfall chart in QlikView - • QlikView Tutorial | Ql...
How to create Candle Stick chart in QlikView - • QlikView Tutorial | Ql...
How to create Mekko Chart in QlikView - • QlikView Tutorial | Ql...
How to create Grid Chart in QlikView - • QlikView Tutorial | Ql...
How to create Trellis bar chart in QlikView - • QlikView Tutorial | Ql...
How to create scatter chart in QlikView - • QlikView Tutorial | Ql...
How to create bubble chart in QlikView - • QlikView Tutorial | Ql...
How to create funnel chart in QlikView - • QlikView Tutorial | Ql...
How to create Simple Chart in QlikView - • QlikView Tutorial | Ql...
How to create pivot table in QlikView - • QlikView | Pivot Tables
How to create Mini Chart in QlikView - • QlikView Tutorial | Ql...
How to create expressions in QlikView - • QlikView | Expressions...
How to create group expression in QlikView - • QlikView tutorials | E...
How to create cyclic dimension or group dimension in QlikView - • QlikView tutorials | E...
How to create expression to drill down in charts - • QlikView Tutorials | Q...
How to create scripts in QlikView - Part 1 - • QlikView Scripting | B...
How to create scripts in QlikView - Part 2- • QlikView Scripting | B...
How to use variable for advanced QlikView expressions - • Advanced variable oper...
How to do partial load in QlikView - • QlikView Tutorial | Ql...
How to do resident load in QlikView - • QlikView Scripting | R...
How to inline load in QlikView - • QlikView tutorial | Ql...
How to concatenate data in qlikview - • QlikView Tutorial | Ql...
How to join data in qlikview - • QlikView Scripting | J...
How to use AGGR function in QlikView with Max function and first sorted value function - • QlikView | Expressions...
How to use AGGR function as calculated dimension - • QlikView | Expressions...
How to use Class function in QlikView - • QlikView Tutorial | Ql...
How to get running total in QlikView - • QlikView Tutorials | E...
How to use wild card character in QlikView set anlaysis - • QlikView | Set Analysi...

Опубликовано:

6 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 21

@TrendzyMayuri 2 года назад

Thank you so much sir… you made it very simple ☺️

@Acheiropoietos 5 лет назад

Very comprehensive overview. Thank you!

@hiteshagrawal326 5 лет назад

Great Job Abhishek....I really liked it

@TheAnkit7777 7 лет назад

Thanks Abhishek. Was really looking forward to this video. Once again great job :)

@bhavyabangera1190 4 года назад

Hi Abhishek, There was an error 404 not found in the URL( google drive link) that you shared in the description box for to download script and Excel data. Could you please upload it again..

@jeffmonroe9716 7 лет назад

Great video. Very helpful and made simple. Thanks.

@raghavendrarao7538 5 лет назад

can u send me the scripting part

@tenyeapenpaul 4 года назад

Hi can we add 2 date feilds to master calender??? From different data set?

@miteshshah7794 3 года назад

There was an error 404 not found in the URL( google drive link) that you shared in the description box for to download script and Excel data. Could you please upload it again..

@d33li1 7 лет назад

How can you create a list box with the fiscal years of Apr-Mar such as 16/17, 17/18, etc?

@AbhishekAgarrwal 7 лет назад

For that you need to specify the start date as mindate and end date as max date in the variables.

@sangramrajpujari3829 4 года назад

Master video for master calendar

@TheAnkit7777 7 лет назад

Hi Abhishek, I don't see the use of this line ($(vMinDate) + IterNo()-1 as DateNum) anywhere in the script. Can you please explain its relevance?

@AbhishekAgarrwal 7 лет назад

Consider this line as a do-while loop and in a simple english statement it means that run the loop until it reaches end and "end" is defined by this line. Hope it helps!

@TheAnkit7777 7 лет назад

Thanks a lot bro. Also is there a way in qlikview that you can assign a date value to a variable directly? e.g. vDate = '01-06-2017' I tried the above initialization and it didn't seem to work. Can you please help with this?

@LearnITwithSreeni 7 лет назад

You can create a variable with SET keyword, like SET vDate = '01-06-2017';

@jeffmonroe9716 7 лет назад

Are the files available? I don't see them in he comments

@AbhishekAgarrwal 7 лет назад

Hi Monroe .. the spreadsheet link is given above. Also the master calendar script is into the same spreadsheet and under the master calendar tab.

@MarcusvanNiekerk 3 года назад

@@AbhishekAgarrwal I really like your video but the link to the spreadsheet is no longer active. Can you provide to me please?

@suryanarayana2153 2 года назад

Hi Abhishek, There was an error 404 not found in the URL( google drive link) that you shared in the description box for to download script and Excel data. Could you please upload it again..