QlikSense tutorial: STOP using IF!!! Use these functions instead !! Peak & match funktions qliksense
📕 Get the Formula CheatSheet: https://www.thinkmetrics.se/cheatsheet
Build your dashboard tutorial: https://youtu.be/AfDaxXQS5No
Sign up for Qlik business free 30 days trial to learn if you don't have access to Qlik : https://www.qlik.com/us/trial/qlik-sense-business
****************************************************************************
#qlik #qliksense #dataviz
0:00 Intro
01:20 HOw Pick works
03:00 Using Match with Pick
05:00 Replacing the Else condition
**********************************************************************
Struggling to get your work done? Check out:
📓 Lazy Man's Guide to productivity, become super productive: https://gumroad.com/l/FssWH
🚀 Productivity Masterclass: Take my Master course on Overcoming procrastination from a former serial procrastinator: https://www.udemy.com/course/master-course-on-overcoming-procrastination/?referralCode=56E545868C330C210FF0
📚 Read on Kindle the simplest way to become ultra-productive:
https://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 - https://twitter.com/kaush_ms
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 😃
Тэги:
#qlik #qlik_sense #data #data_viz #data_vizualization #metrics #sql #dashboard #data_dashboard #business_analytics #analytics #data_analytics #data_science #data_analyst #data_scientist #business_intelligence #BI #tableau #power_bi #microsoft #learning #how_to #tutorial #how_to_qlik #how_to_tutorial #qliksense_tutorial #learn_data_for_free #learn_qliksense_free #qlik_sense_free_tutorial #full_tutorial #beginners #build_first_app #qliksense_full_tutorial #code #script_editor #data_modelКомментарии:
very informative
Ответить
Cuales son los resultados al usar if vs peak?
Ответить
Hi Thinkmetrics
I have a query regarding pick match.
Let say I have multiple value of geography and there are some null values as well. I want the null values to be tagged as 'NA' and rest all the geography value would be same as the value available in geography. It might be the case that some geography value may add in the near future so we need to write the code like we do not need to make enhancement in the code
🎉
Ответить
Can we do pick and match for more than 2 conditions?
Ответить
Will pick and match work for every "if expression" like even if there is a Boolean expression ?
Ответить
Great stuff!
Ответить
Can you please do one with set analysis. e.g If(SUM({<States = {'TX', 'CA'}, Sales1ID = {1,3}>}Sales1) >= 10000, black(), blue())
Ответить
Please share real time tips for qlik dashboard optimization
Ответить
