Thinkmetrics
Thinkmetrics
  • 174
  • 605 279
Qliksense: Create Dynamic Measures in the front end without self service #qlik
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
🗄️ Qlik template file: crafty-knitter-8087.kit.com/products/dynamic-front-end
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 😃
Переглядів: 328

Відео

QlikSense: Create Dynamic Number Formatting in the front end 🔄 #qlik #qliksense
Переглядів 315Місяць тому
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 🗄️ Qlik template file: crafty-knitter-8087.kit.com/products/dynamic-front-end Full intro to dashboarding tutorial: ua-cam.com/video/FT2KB1M_-bI/v-deo.html Build your dashboard tutorial:...
QlikSense Tutorial: How to switch measures in a graph using BUTTONS in QlikSense #qlik #qliksense
Переглядів 6513 місяці тому
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/...
Qlik is frustrating.. Qlik Missing features PART 1
Переглядів 3823 місяці тому
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 Story Telling mode 101
Переглядів 4863 місяці тому
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: Install custom Extensions
Переглядів 3264 місяці тому
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
Переглядів 4334 місяці тому
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
Переглядів 3465 місяців тому
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
Переглядів 8505 місяців тому
Qliksense & ChatGPT. TAlk to GPT4 using QlikSense Front End
QlikSense tutorial: How to Rank items in the script hack. #qliksense #qlik
Переглядів 6976 місяців тому
QlikSense tutorial: How to Rank items in the script hack. #qliksense #qlik
QLIK SENSE: Build beautiful dashboards using the Layout container. #qlik #dashboarding
Переглядів 1,1 тис.8 місяців тому
QLIK SENSE: Build beautiful dashboards using the Layout container. #qlik #dashboarding
QlikSense layout container magic
Переглядів 6759 місяців тому
QlikSense layout container magic
QlikSense: Creating a Show and Hide button in layout container
Переглядів 2,1 тис.9 місяців тому
QlikSense: Creating a Show and Hide button in layout container
QlikSense basics: Elevating the your dashboard using Layout container. #qliksense #dataviz
Переглядів 9379 місяців тому
QlikSense basics: Elevating the your dashboard using Layout container. #qliksense #dataviz
QlikSense Hacks: Create custom time axis in Qliksense
Переглядів 92611 місяців тому
QlikSense Hacks: Create custom time axis in Qliksense
Qlik Sense: Dynamic Dimensional Reference Lines
Переглядів 1,1 тис.Рік тому
Qlik Sense: Dynamic Dimensional Reference Lines
QlikSense: Conditional coloring for different dimensional hierarchy.Dimensionality() function
Переглядів 679Рік тому
QlikSense: Conditional coloring for different dimensional hierarchy.Dimensionality() function
QlikSense : Automatic selection and & navigation using Buttons
Переглядів 1,2 тис.Рік тому
QlikSense : Automatic selection and & navigation using Buttons
QlikSense tutorial: Make life EASIER with WINDOW FUNCTION in Qliksense
Переглядів 2,9 тис.Рік тому
QlikSense tutorial: Make life EASIER with WINDOW FUNCTION in Qliksense
Qliksense : Previous function trick. Using Previous instead of Peek
Переглядів 1,8 тис.Рік тому
Qliksense : Previous function trick. Using Previous instead of Peek
QlikSense vs Equals- The New Age Spreadsheet.
Переглядів 758Рік тому
QlikSense vs Equals- The New Age Spreadsheet.
Qliksense: Creating composite keys 🔑 & Autonumber function
Переглядів 1,9 тис.Рік тому
Qliksense: Creating composite keys 🔑 & Autonumber function
Qliksense : Peek function trick. Find previous month status using Peek
Переглядів 1,6 тис.Рік тому
Qliksense : Peek function trick. Find previous month status using Peek
QlikSense tutorial: How to calculate Rolling 12 months
Переглядів 4,5 тис.Рік тому
QlikSense tutorial: How to calculate Rolling 12 months
Qlik Sense tutorial: MUST WATCH !Custom user interactive dashboard using buttons .DASHBOARD MAGIC !!
Переглядів 2,1 тис.Рік тому
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,5 тис.Рік тому
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.
Переглядів 7 тис.Рік тому
QlikSense for beginners Full Tutorial: Build your first QlikSense app with the script editor.
QlikSense Tutorial: Script function: Resident Load VS Preceding Load
Переглядів 2,7 тис.Рік тому
QlikSense Tutorial: Script function: Resident Load VS Preceding Load
QlikSense tutorial : How to apply Alternate state sheets and use inherited states in QlikSense.
Переглядів 1,1 тис.Рік тому
QlikSense tutorial : How to apply Alternate state sheets and use inherited states in QlikSense.

КОМЕНТАРІ

  • @SAKIBHUSSAININ
    @SAKIBHUSSAININ 7 днів тому

    I have been struggling for 45 days Thank you this was a great trick 🎉❤

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

      👍🏻👍🏻👍🏻👍🏻

  • @Na-uy4ot
    @Na-uy4ot 9 днів тому

    Also I agree these features Qlik lacks are so annoying!

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

    Are there any Caveats to using the returned value from the lookup field in a where clause? Or is it write like usual? E.g. where field1 = lookupField1

  • @rashmitapradhan1529
    @rashmitapradhan1529 13 днів тому

    Can we go to external shared folder links using this method to fetch a pdf file?

  • @samiberhaiem4882
    @samiberhaiem4882 18 днів тому

    Thank you for sharing ! very good work !

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

    👌

  • @amalsagar9074
    @amalsagar9074 24 дні тому

    Hi Sir , I have some doubts in qlik . How can I contact you ?

  • @thenmozhiarul4391
    @thenmozhiarul4391 26 днів тому

    Hi., can we add custom tooltip to table or pivot table visual

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

    I Bought the file and can not open it in Winrar, I have to pay for that as well. Can you send me another format of the file ?

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

      The file is FREE!!!! You have to unzip to get the data and file. Google how to unzip a file.

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

      @@thinkmetrics How is it free when there exist a lower limit of 5 dollars in order to download it ? I did not let me download before I paid.

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

    Could you share Qlik NPrinting videos?

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

    Is it list box in qliksense? I gone through qlik community official documentation but not getting how to create list box as they have provided code but i am not getting where I need to write that code in data load editor or qlik dev hub extension I am requesting you to please help me on that...

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

    Is it list box in qliksense?

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

      Variable input. There you can choose drop down list

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

    Thank you very much for your share

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

    Total ignors the dimention and accepta the selection 3:33

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

    Obrigado pela ajuda mano/ Thank you, man.

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

    Hi, good video thanks. It is also very interesting to work with the chronology of events in Qlik Sense.

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

    Hi! It is more interesting if the formats differ functionally. for example: an integer, a percentage of the amount, a place in the rating. Thanks for your videos.

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

      Good point! and that can be easily done. Just change the format to show percentage rating instead.

  • @abraham.j
    @abraham.j Місяць тому

    Welcome Back!!

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

    GREAT! THANKS!

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

      🙌🏻🙌🏻🙌🏻🙌🏻

  • @Dave-nz5jf
    @Dave-nz5jf Місяць тому

    "this is why I should be wearing my glasses". Literally the same thing I was thinking at the same instant. Shoulda zoomed in :)

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

    Would be good to see examples showing all of the Window() functions parameters, e.g. the sliding window start/end too.

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

    Hello, thanks for the tutorial! It seems to work by taking the value of a "field" but not the value of the dimension. Is there a way to make it pick the value of the dimension instead of the field? For example, if you assign some colors int the dimension "Country" USA -> blue, selecting then the USA won't show the blue color. This is because it is linked to the field and not the dimension. Is there a way to fix this?

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

      I find that strange. You could use the match function to catch the dimension value and assign a color to it, right?

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

      @@thinkmetrics the idea is that the color is defined in the dimension already. I don't wish to re-assign new colors in another place. can you give it a try to see if you manage to reproduce my problem?

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

      @@danielteixeira3974 Sure.

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

    Expression for master measures on time and cancelled?

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

    @Thinkmetrics Hey thanks for this. Helps a great deal. 1 doubt though, can we have default template as a slide in the app, so that whatever we create is created on that template, then replicate the same template for multiple slides ? Thanks in advance.

  • @ANKITKUMAR-uf1sh
    @ANKITKUMAR-uf1sh 2 місяці тому

    Hi, is cheat sheet is free with qs master course

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

    8:00 is where exactly it interacts with OPEN AI

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

    Such a great work, this helped me alot 👌

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

    Can I get your email id I have some doubts regrading your Qliksense Masterclass course as I wanted to purchase course

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

    Thank you for this, exactly what I needed 🙏🏻

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

    Great! Thank you

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

    Hi b, how to get freely qlik sense desktop

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

      I suggest you use Qlik cloud.

    • @ANKITKUMAR-uf1sh
      @ANKITKUMAR-uf1sh 2 місяці тому

      ​@@thinkmetrics is cheat sheet free with Qliksense master class course

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

    👍

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

    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 3 місяці тому

      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 3 місяці тому

    Your explanation is simple and efficient. Thanks for that!

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

      🙌🏻🙌🏻🙌🏻🙌🏻

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

    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 4 місяці тому

    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 4 місяці тому

    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 4 місяці тому

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

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

    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 4 місяці тому

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

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

    Excellent !!

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

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

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

    How to sort the columns based on selection in table

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

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

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

    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?

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

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

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

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

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

    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 5 місяців тому

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

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

      If you can get the area coordinates

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

    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!

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

    thansk! love it