Thinkmetrics
Thinkmetrics
  • 166
  • 560 252
QlikSense Story Telling mode 101
Script in the cheatsheet:
📕 Get the Formula CheatSheet: crafty-knitter-8087.ck.page/products/qlik-sense-front-end-formula-cheatsh?
Sign up for the vizualization course: crafty-knitter-8087.ck.page/6b1c804c0c
Full intro to dashboarding tutorial: ua-cam.com/video/FT2KB1M_-bI/v-deo.html
Build your dashboard tutorial: ua-cam.com/video/AfDaxXQS5No/v-deo.html
Script editor tutorial: ua-cam.com/video/Lrf8JkXlYWQ/v-deo.html
🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass
🤖 Get the new AI & QlikSense : Integrating ChatGPT into Qliksense. Get GPT 3.5 Turbo & Text-Davinci-003 model script : crafty-knitter-8087.ck.page/products/qlik-chatgpt?promo=QLIKAI
Longer length indepth chatGPT tutorial:
ua-cam.com/video/hD5MmoWZlWM/v-deo.html
Download the Data file: kaush.gumroad.com/l/znwmbv
#qliksense #dataviz #qlik #chatgpt #ai
Sign up for Qlik business free 30 days trial to learn if you don't have access to Qlik : www.qlik.com/us/trial/qlik-sense-business
****************************************************************************
#qliksense #dataviz
**********************************************************************
Struggling to get your work done? Check out:
📓 Lazy Man's Guide to productivity, become super productive: gumroad.com/l/FssWH
🚀 Productivity Masterclass: Take my Master course on Overcoming procrastination from a former serial procrastinator: www.udemy.com/course/master-course-on-overcoming-procrastination/?referralCode=56E545868C330C210FF0
📚 Read on Kindle the simplest way to become ultra-productive:
www.amazon.com/Lazy-Mans-Guide-Productivity-Procrastination-ebook/dp/B07HKGHCT5/ref=sr_1_3?ie=UTF8&qid=1545837561&sr=8-3&keywords=lazy+mans+guide+to+productivity
🐦 Twitter - kaush_ms
TikTok - @thinkmetrics
WHO AM I:
🙋🏻‍♂️ I'm Kaush, a Data Analyst and Data Visualization Developer working for a tech company. I live and work in Sweden. I make videos about technology, productivity, and lifestyle design. Say hi to me on Twitter 😃
Переглядів: 163

Відео

QlikSense: Install custom Extensions
Переглядів 18821 день тому
Script in the cheatsheet: 📕 Get the Formula CheatSheet: crafty-knitter-8087.ck.page/products/qlik-sense-front-end-formula-cheatsh? Sign up for the vizualization course: crafty-knitter-8087.ck.page/6b1c804c0c Full intro to dashboarding tutorial: ua-cam.com/video/FT2KB1M_-bI/v-deo.html Build your dashboard tutorial: ua-cam.com/video/AfDaxXQS5No/v-deo.html Script editor tutorial: ua-cam.com/video/...
Installing custom themes in QLikSense
Переглядів 22328 днів тому
Script in the cheatsheet: 📕 Get the Formula CheatSheet: crafty-knitter-8087.ck.page/products/qlik-sense-front-end-formula-cheatsh? Sign up for the vizualization course: crafty-knitter-8087.ck.page/6b1c804c0c Full intro to dashboarding tutorial: ua-cam.com/video/FT2KB1M_-bI/v-deo.html Build your dashboard tutorial: ua-cam.com/video/AfDaxXQS5No/v-deo.html Script editor tutorial: ua-cam.com/video/...
Qliksense: Create Drill down maps with KML files in QlikSense
Переглядів 240Місяць тому
Script in the cheatsheet: 📕 Get the Formula CheatSheet: crafty-knitter-8087.ck.page/products/qlik-sense-front-end-formula-cheatsh? Sign up for the vizualization course: crafty-knitter-8087.ck.page/6b1c804c0c Full intro to dashboarding tutorial: ua-cam.com/video/FT2KB1M_-bI/v-deo.html Build your dashboard tutorial: ua-cam.com/video/AfDaxXQS5No/v-deo.html Script editor tutorial: ua-cam.com/video/...
Qliksense & ChatGPT. TAlk to GPT4 using QlikSense Front End
Переглядів 532Місяць тому
Script in the cheatsheet: 📕 Get the Formula CheatSheet: crafty-knitter-8087.ck.page/products/qlik-sense-front-end-formula-cheatsh? Connect to Open AI using Rest API video: ua-cam.com/video/hD5MmoWZlWM/v-deo.html ua-cam.com/video/x58lUD3QJN0/v-deo.html Full intro to dashboarding tutorial: ua-cam.com/video/FT2KB1M_-bI/v-deo.html Build your dashboard tutorial: ua-cam.com/video/AfDaxXQS5No/v-deo.ht...
QlikSense tutorial: How to Rank items in the script hack. #qliksense #qlik
Переглядів 5653 місяці тому
Full intro to dashboarding tutorial: ua-cam.com/video/FT2KB1M_-bI/v-deo.html Build your dashboard tutorial: ua-cam.com/video/AfDaxXQS5No/v-deo.html Script editor tutorial: ua-cam.com/video/Lrf8JkXlYWQ/v-deo.html 🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass 📕 Get the Formula CheatSheet: crafty-knitter-8087.ck.page/products/qlik-sense-front-end-formula-cheatsh?promo=UA-cam Us...
QLIK SENSE: Build beautiful dashboards using the Layout container. #qlik #dashboarding
Переглядів 8065 місяців тому
Layout container Templates: crafty-knitter-8087.ck.page/products/layout-container Full intro to dashboarding tutorial: ua-cam.com/video/FT2KB1M_-bI/v-deo.html Build your dashboard tutorial: ua-cam.com/video/AfDaxXQS5No/v-deo.html Script editor tutorial: ua-cam.com/video/Lrf8JkXlYWQ/v-deo.html 🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass 📕 Get the Formula CheatSheet: crafty-...
QlikSense layout container magic
Переглядів 5726 місяців тому
Full intro to dashboarding tutorial: ua-cam.com/video/FT2KB1M_-bI/v-deo.html Build your dashboard tutorial: ua-cam.com/video/AfDaxXQS5No/v-deo.html Script editor tutorial: ua-cam.com/video/Lrf8JkXlYWQ/v-deo.html 🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass 📕 Get the Formula CheatSheet: crafty-knitter-8087.ck.page/products/qlik-sense-front-end-formula-cheatsh?promo=UA-cam Us...
QlikSense: Creating a Show and Hide button in layout container
Переглядів 1,6 тис.6 місяців тому
Full intro to dashboarding tutorial: ua-cam.com/video/FT2KB1M_-bI/v-deo.html Build your dashboard tutorial: ua-cam.com/video/AfDaxXQS5No/v-deo.html Script editor tutorial: ua-cam.com/video/Lrf8JkXlYWQ/v-deo.html 🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass 📕 Get the Formula CheatSheet: crafty-knitter-8087.ck.page/products/qlik-sense-front-end-formula-cheatsh?promo=UA-cam Us...
QlikSense basics: Elevating the your dashboard using Layout container. #qliksense #dataviz
Переглядів 7986 місяців тому
QlikSense basics: Elevating the your dashboard using Layout container. #qliksense #dataviz
QlikSense Hacks: Create custom time axis in Qliksense
Переглядів 8318 місяців тому
QlikSense Hacks: Create custom time axis in Qliksense
Qlik Sense: Dynamic Dimensional Reference Lines
Переглядів 1 тис.10 місяців тому
Qlik Sense: Dynamic Dimensional Reference Lines
QlikSense: Conditional coloring for different dimensional hierarchy.Dimensionality() function
Переглядів 60810 місяців тому
QlikSense: Conditional coloring for different dimensional hierarchy.Dimensionality() function
QlikSense : Automatic selection and & navigation using Buttons
Переглядів 1 тис.10 місяців тому
QlikSense : Automatic selection and & navigation using Buttons
QlikSense tutorial: Make life EASIER with WINDOW FUNCTION in Qliksense
Переглядів 2,6 тис.Рік тому
QlikSense tutorial: Make life EASIER with WINDOW FUNCTION in Qliksense
Qliksense : Previous function trick. Using Previous instead of Peek
Переглядів 1,6 тис.Рік тому
Qliksense : Previous function trick. Using Previous instead of Peek
QlikSense vs Equals- The New Age Spreadsheet.
Переглядів 730Рік тому
QlikSense vs Equals- The New Age Spreadsheet.
Qliksense: Creating composite keys 🔑 & Autonumber function
Переглядів 1,6 тис.Рік тому
Qliksense: Creating composite keys 🔑 & Autonumber function
Qliksense : Peek function trick. Find previous month status using Peek
Переглядів 1,4 тис.Рік тому
Qliksense : Peek function trick. Find previous month status using Peek
QlikSense tutorial: How to calculate Rolling 12 months
Переглядів 4,1 тис.Рік тому
QlikSense tutorial: How to calculate Rolling 12 months
Qlik Sense tutorial: MUST WATCH !Custom user interactive dashboard using buttons .DASHBOARD MAGIC !!
Переглядів 1,9 тис.Рік тому
Qlik Sense tutorial: MUST WATCH !Custom user interactive dashboard using buttons .DASHBOARD MAGIC !!
QlikSense & ChatGPT: Connect QlikSense to ChatGPT and analyze data using Text-Da-Vinvi-003 model.
Переглядів 1,4 тис.Рік тому
QlikSense & ChatGPT: Connect QlikSense to ChatGPT and analyze data using Text-Da-Vinvi-003 model.
QlikSense & ChatGPT: How to connect QlikSense to ChatGPT and analyze data using GPT 3.5 turbo model.
Переглядів 6 тис.Рік тому
QlikSense & ChatGPT: How to connect QlikSense to ChatGPT and analyze data using GPT 3.5 turbo model.
QlikSense for beginners Full Tutorial: Build your first QlikSense app with the script editor.
Переглядів 6 тис.Рік тому
QlikSense for beginners Full Tutorial: Build your first QlikSense app with the script editor.
QlikSense Tutorial: Script function: Resident Load VS Preceding Load
Переглядів 2,4 тис.Рік тому
QlikSense Tutorial: Script function: Resident Load VS Preceding Load
QlikSense tutorial : How to apply Alternate state sheets and use inherited states in QlikSense.
Переглядів 903Рік тому
QlikSense tutorial : How to apply Alternate state sheets and use inherited states in QlikSense.
QlikSense tutorial: Dynamic maps using user input variable
Переглядів 794Рік тому
QlikSense tutorial: Dynamic maps using user input variable
QlikSense tutorial: Comparative Alternate states using set operators 101 in QlikSense
Переглядів 610Рік тому
QlikSense tutorial: Comparative Alternate states using set operators 101 in QlikSense
QlikSense tutorial: Syncing fields automatically - Advanced Alternate States
Переглядів 884Рік тому
QlikSense tutorial: Syncing fields automatically - Advanced Alternate States
QlikSense Tutorial: Comparative Analysis using Alternate states 101
Переглядів 1,1 тис.Рік тому
QlikSense Tutorial: Comparative Analysis using Alternate states 101

КОМЕНТАРІ

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

    Qlik is the worst, I am so used to Power BI, and now have to do a project in Qlik, it's terrible just to do the basics. I mean you can't even change the column width easily. It's just tedious

    • @thinkmetrics
      @thinkmetrics 5 днів тому

      Haha. Yes, those who start with PowerBI find it hard initially to wrap their heads around how Qlik works. But Qlik has its advantages. Let me know how I can help.

  • @user-lr4qt3tj8p
    @user-lr4qt3tj8p 7 днів тому

    Your explanation is simple and efficient. Thanks for that!

    • @thinkmetrics
      @thinkmetrics 5 днів тому

      🙌🏻🙌🏻🙌🏻🙌🏻

  • @hinaqayyum8926
    @hinaqayyum8926 20 днів тому

    Hi, I am interested in your master class, I have a question though, if I join will I have access to the videos and can watch and re watch or do you take live classes, Thanks.

  • @ChintanWagh-j5c
    @ChintanWagh-j5c 26 днів тому

    Could you please make a video explaining how Geo analytics is used in Qliksense and how to use the different mapping techniques based on an insurance dataset?

  • @ChintanWagh-j5c
    @ChintanWagh-j5c 26 днів тому

    Thank you so much for your guidance! You have done a great job! I was able to implement all the steps and build an exact dashboard.

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

    Could you teach how to create extension.... Thanks for video

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

    I'm having some interviews with a company and they gave me your video to exercise on Qlik, which I never used. I loved it!!

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

      That is awesome! Which company is this? Good luck with Qlik.

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

    Excellent !!

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

    Hi sir, I want to prepare for N- printing Qlik administration Where can I learn these tools Can u suggest any platform

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

    How to sort the columns based on selection in table

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

    Can you explain how wrank window function works in Qlik Sense?

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

    You put your variable value in square brackets ie ‘[lib://DataFiles/]’ but why not simply ‘lib://DataFiles/’ ? Unfortunately you didn’t run the script in the video to see the outcome. Surely additional square brackets in the resulting file address would have tripped this up and Qlik wouldn’t have found the necessary data files? Or does Qlik natively ignore the square brackets in this situation?

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

    I am getting a 'Too Many Requests' error. Could you please help me with this?

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

    Thanks, can you please show us how to calculate CAGR (Compounded Annual Growth Rate) in qlik

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

    Hi, please make a video on how to pick the latest subfolder created in parent folder and the subfolder name is based on date, like 'Jan 2022'. Also pick the latest file available in subfolder.

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

    Is it possible to drill further down to a lot plat map? I want to be able to show lots/plats.

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

      If you can get the area coordinates

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

    Hi! You can do the same with one layer in the map object. just need to create another master item (drilldown) with the names and put it in dimensions thanks man I already learn a lot from you!

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

    thansk! love it

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

    Qlik Enterprise doesn’t have Analytic Conncetors. Do you think this can be done by script in Qlik Enterprise ?

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

      Use the rest api instead. Check out the other video

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

    Qlik, and you are making life simpler.

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

    Good video. We are now moving back to qlik view with objects everywhere

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

      And life comes back full circle haha

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

    Great tutorial

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

    If I want all the field we will * , but then it wont allow to use the same column name is there any way for it

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

    Hi Kaush, Great video! If we purchase your scripts, are they updated to work with the current version of OpenAI, or are they still based on the 2023 version (when the video was made)?

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

      Yes. It works perfectly fine !!!! Good luck 🍀

  • @Samet-p2z
    @Samet-p2z 2 місяці тому

    Your explanation is truly amazing, you explained in an hour what I have been trying to learn for a month. Do you have a chance to give it to me for free? When I earn money, I promise I will buy it. I have never seen an educator who explains it as well as you. I believe I will achieve a lot with your lessons.

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

      Send me an email

    • @Samet-p2z
      @Samet-p2z 2 місяці тому

      @@thinkmetrics

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

      @@thinkmetrics gönderemiyorum başka bir yolu var mı bu ikini epostam

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

    amazing

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

    great video and replacement for Adhoc Builder extension

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

    I want to contact with you , can i have your email please for business!!

  • @СуперМаг-у9й
    @СуперМаг-у9й 2 місяці тому

    Keys to Qlik Sense in any quantity: t me QlikSenseBuyChat

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

    Hi , The dashboard is very nice, thank you. Can you give me the Qvf file or is there a place we can get it from? I need sample dashboards

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

    Don't know why but this is not working outside table in my case. Can you help? Is there any change in the function? I am using the same content and same function as shown in the video.

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

    Thanks much ❤

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

    Hai, can you make video for mashup ?

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

    wouldn't the 'temp' table form a normal concatenation with the Map_data table above it as they contain same column names???

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

    Hi, thanks for the video, that's exactly what I was looking for. Is there any way to use them as a filter? Ideally what I would want is to be able to select a color and the graph to update, particularly in a scatter plot

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

      Yes. You can use getfieldselections n use that as an input for color.

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

    excelent!

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

    Thank you!

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

    Master Calendar Script is not there in the links provided.

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

    Hi brother, i guess we can also use above function here which will directly give us the same output… can we ?

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

    😊

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

    Another great video and useful "colouring" website. Can I have the notion template from a ig fan in Cyprus

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

      🙏🙏🙏🙏. Yes. Soon.

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

    Fantastic... thank you

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

    The audio quality is not so good

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

      🎶🎶🎶🎶⬆️⬆️⬆️⬆️

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

    Hi, can you make a detailed video series on Section access i.e. app level, sheet level, object level, row and field level. Thanks :)

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

      👍🏻

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

      @@thinkmetricsyes I would be hugely in favour of this too. Pretty please. Plus also I am having great success with your previous content. I really appreciate your work. Thank you!

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

    Hi, can you make a video on Window rank function explaining its parameters in detail.

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

      data_temp: load * inline [ Region, Sales North, 5000 South, 1000 East, 2000 West, 600 ]; data: Load Region, RowNo(), sum(Sales) as sales_total resident data_temp group by Region order by Sales desc; drop table data_temp;

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

      Send an email with your queries

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

    Hi, I have got a question asked in an interview. I have to rank the data in the backend. How can I achieve this??? Region Sales North 5000 South 1000 East 2000 West 600 Desired Output Region Sales Rank North 5000 1 East 2000 2 South 1000 3 West 600 4

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

      data_temp: load * inline [ Region, Sales North, 5000 South, 1000 East, 2000 West, 600 ]; data: Load Region, RowNo(), sum(Sales) as sales_total resident data_temp group by Region order by Sales desc; drop table data_temp;

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

    Brother how to show the last 5 dates in x- axis bar chart

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

      =Aggr( If( Rank(DateField) <= 5, DateField ), DateField )

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

      @@AnkitPandey-ju1ff thank you so much brother for your help

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

    * is not working in Qlik Saas, how to do the same in Saas

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

      It works on Qlik SaaS.

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

      @@thinkmetrics I tried but it is throwing me an error, I am loading the files from Azure container

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

    Can this work for Combo chart? e.g. Variable input 1 is Revenue (Bar chart) , 2 is Gross Profit (combo chart with Gross profit as a bar and gross margin as a line chart)?

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

      Yes. But using buttons to hide and show the graphs. Check out the video on it.

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

    I use this myself, but there are multiple masters that explain that this is not in any way faster than IF. It may seem simpler (and I believe it is), but it is not computationally faster at all.