Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are marching right into March! This month, we are featuring another rising star in the Qlik Community. This person is a leader on our weekly and monthly leaderboard. He has posted more than four hundred times and received as many likes. He has earned the rank of Specialist in the Community and is also a member of Qlik Nation. It is with immense pleasure to introduce our March featured member Henrik Almen, AKA henrikalmen.
Henrik’s journey in his own words:
“In 2014, I had a position that included various analysis tasks and database queries. A manager from another department approached me and said something like, “We have this tool, QlikView, that we should use more, and I think you should study it and become our BI Developer - what do you say? Your career will benefit from it when you eventually want to move on from here.”
Naturally, I said yes, then attended a QlikView training course and earned a developer certification. As suggested to me, it was a smart career move.
The Qlik community forum quickly proved to be an incredibly useful resource. It was essential when I started to learn QlikView, and it continued to help me when I transitioned to Qlik Sense. It still supports me after years as a Qlik developer.
I learn so much from reading other people's posts and replies, and I challenge myself by trying to find solutions to tricky issues. I also help by explaining what's happening and/or pointing questioners in the right direction instead of serving them with a solution. Learning something new benefits the user in the long run rather than applying a ready-made solution he or she might not fully understand.
In my spare time, I sing in the vocal band Vocal Brand; you can listen to us on your preferred music streaming service or at https://www.youtube.com/@vocalbrand.”
Henrik’s band is so impressive, such exceptional talent. I would urge you to follow our rising on his YouTube channel and friend him on the Qlik Community! Let’s show our appreciation for Henrik’s contributions by leaving a comment and hitting that like button. @Melissa_Potvin @Jamie_Gregory @nicole_ulloa @henrikalmen
Analyze personal usage in LinkedIn network
Get insights about your LinkedIn profile
LinkedIn users who want to explore their activity on LinkedIn
It encourages other LinkedIn users to request their own data and create a personal dashboard
If team plays game at home, they score more, and win the games more often
It didn't, I did it just for myself 🙂
I showed it just to my Professor at my Business Informatics studies and my colleagues from the group. They liked it.
I used alternate states for it, to enable on one side of the dashboard to select games played at home, and on the second side games played away.
Qlik Learning is excited to announce the release of our new Data Literacy Qualification Exam!
Data Literacy Qualification Exam is a non-technical, product-agnostic exam, measuring an individual’s fundamental-level and applied understanding of skills and abilities to read, work with, analyze and communicate with data. This is a timed, 1 hour, 30 question multiple-choice exam. See here to get more details on the exam topics and preparation resources.
To get started with the exam, visit the Qlik Learning Portal, then choose Assessments from the top navigation→ Qualifications → Data Literacy
Upon successfully passing the exam, you will earn a certificate of completion, a Credly digital badge for sharing on Social Sites and of course; bragging rights!
Questions? Feedback? Reach out to education@qlik.com
Happy Learning!
Delve into multiple options to visualize and customize ranges and moments, set markers and labels, configure axes, navigation, tooltips, and much more demonstrated in action.
Timeline charts ensure an illuminating overview of a series of events in chronological order.
Data visualizers and analysts seeking to create compelling timeline charts within their applications in Qlik Sense.
This app features timeline visualizations powered by AnyChart's Timeline Chart extension for Qlik Sense, using fictional data to illustrate its capabilities.
We are looking for a BI Developer to support a small team and help to provide various departments
with their KPIs, reports, and ad-hoc analysis. You will play a critical role in the optimal use of existing
data sources and building new solutions to meet the analysis demands of the business and report to
the Head of Business Intelligence. Please go to www.booming-games.com to apply.
What we do: Since 2015, we deliver high-end gaming to the online casino slots market and offer
uniquely themed games with innovative features.
Where we work: In our offices in Berlin and Malta, and remotely.
Who we are: Around 80 talents from 20 different nations in different locations with different
backgrounds but one team spirit.
What we are proud of: Our growth, a permanent improvement of quality and all our skillful
professionals who make it possible.
We offer: The possibility to drive ideas into reality and to take ownership from day one.
This Techspert Talks session covers:
Chapters:
Resources:
Q&A:
Q: What is the most efficient way to apply set analysis to a numeric field using a variable returning a string? They both represent dates.
A: Change the format of the numeric field to a string. If it is a date, use the Date() function. And then use wildcards and other string functions.
Q: What about the {<[PROD] = $::[PROD] >} statement in set expressions? Please explain.
A: The double colon (::) sets the expression to use the Default State. Here is documentation with more details: Synchronizing Selections between States
Q: sum({-<qty = {'*'}>} ContractAmount)
A: This is using an operator to exclude everything from the qty dimension.
Q: =Sum({$-<[Top BU]={'*'}>} Sales)
A: This is using an operator to exclude everything from the Top BU dimension. Using the '-' with the identifier excludes all values that are not null.
Click here to see video transcript
April 10, 2024 08:30:00 AM||Join our live Qlik Technical Workshops to get hands-on guidance from our Adoption Specialists.||April 10, 2024|| || 8:30 AM ET ||https://pages.qlik.com/Qlik_Technical_Workshops.html
||Join us for a live Q&A session to answer any questions you have regarding the Qlik Community and the migration of the former Talend Community.||March 20, 2024||11 AM ET || || https://qlik.zoom.us/webinar/register/WN_LSRu57tLRm-84kwalZ3KOQ
||Sign Up!
|| Elevate your career with Connect. 15 Hands on workshops and certifications for Data and Analytics ||June 3-5, 2024||Orlando, Fl. || ||
https://www.qlikconnect.com?utm_campaign=7013z000001vmSqAAI&utm_content=QlikCommunity&utm_medium=social&utm_source=QlikCommunity&utm_custom=CST&utm_term=QlikCommunity&utm_mpt_id=CXJJLP |
||Learn More
March 26, 2024 10:00:00 AM||Let our Qlik experts help you with your dashboard, app, and visualization related questions.||March 26, 2024|| || 10 AM ET ||https://pages.qlik.com/Community_Q_A.html
||Join Michael Tarallo, along with special guests Product Manager Andrew Kruger and Principal Platform Architect Johnny Poole, for part 2 of Qlik Tabular Reporting.||March 27, 2024||10 AM ET|| ||https://pages.qlik.com/DoMorewithQlikWebinarSeriesMarch_Reg.html?utm_campaign=&utm_medium=webinar&utm_source=QlikCommunity&utm_team=GPR&utm_content=mtoComm327&utm_term=mtoComm327 ||Sign me up!
Hi Guys,
I have a field called month1 and want to create a field called financial month starting april month to mar month but when I select fy 23 in a new field called financial year it should calculate.
Please reply asap
We are marching right into March! This month, we are featuring another rising star in the Qlik Community. This person is a leader on our weekly and monthly leaderboard. He has posted more than four hundred times and received as many likes. He has earned the rank of Specialist in the Community and is also a member of Qlik Nation. It is with immense pleasure to introduce our March featured member Henrik Almen, AKA henrikalmen.
Henrik’s journey in his own words:
“In 2014, I had a position that included various analysis tasks and database queries. A manager from another department approached me and said something like, “We have this tool, QlikView, that we should use more, and I think you should study it and become our BI Developer - what do you say? Your career will benefit from it when you eventually want to move on from here.”
Naturally, I said yes, then attended a QlikView training course and earned a developer certification. As suggested to me, it was a smart career move.
The Qlik community forum quickly proved to be an incredibly useful resource. It was essential when I started to learn QlikView, and it continued to help me when I transitioned to Qlik Sense. It still supports me after years as a Qlik developer.
I learn so much from reading other people's posts and replies, and I challenge myself by trying to find solutions to tricky issues. I also help by explaining what's happening and/or pointing questioners in the right direction instead of serving them with a solution. Learning something new benefits the user in the long run rather than applying a ready-made solution he or she might not fully understand.
In my spare time, I sing in the vocal band Vocal Brand; you can listen to us on your preferred music streaming service or at https://www.youtube.com/@vocalbrand.”
Henrik’s band is so impressive, such exceptional talent. I would urge you to follow our rising on his YouTube channel and friend him on the Qlik Community! Let’s show our appreciation for Henrik’s contributions by leaving a comment and hitting that like button. @Melissa_Potvin @Jamie_Gregory @nicole_ulloa @henrikalmen
One is the Order table which contains Ordered_Date and another is the Invoice table which contains GL_date. From these date columns, I extract the Year from each of the tables. Like from the order table, I extract the year from the order date and in the invoice table I extract the year from gl_date. Now I want to create a master calendar by linking the year from both tables and using the master calendar Year in my analysis. Is it possible? What will be the code if someone can tell me and How can I relate to the data manager or something?
I'm trying to make a master calendar which links gl_date from the invoice table with the ordered date in the order table but when I create a data bridge it shows me 4 tables why is it? After this, I don't how to make the master calendar code. Anyone who can help me make the code or fix it? I just want the year and month only in canonical date calendar or master calender. I want to use year from gl_Date and filter my results based on that. The common order number in both tables
I want to use a filter year ok. The year will be extracted from GL_DATE and when I select 2021 it should match with year of the Ordered date which I have already taken out in the order lines table. The gl_date is in the invoice table. The only common relation between both is Order Number. I want to use this in a KPI. I tried using these but it gives me zero
Count({<GL_YEAR = {"$(=only(Ordered_year))"}, FLOW_STATUS_CODE = {'AWAITING_SHIPPING'}>} FLOW_STATUS_CODE)
//Count({<GL_YEAR = {"$(=only({<Ordered_year = {"*"}>} Ordered_year)))"}, FLOW_STATUS_CODE = {'AWAITING_SHIPPING'}>} FLOW_STATUS_CODE)
Can anyone fix it where I went wrong or make a code to fix my issue I saw the master calendar and canonical date but dk how to make the code for it as people are doing on same table. I have two table which have different dates and I want to do analysis based on there year and the common between them is order number. I want to use gl year as my filter but want it to match with order year once 2021 is selected from gl_year.
Hi Guys,
I have lot of sub fields in a single column how to make this data structure.
Kindly reply asap because it is little urgent
I have even attached the image for the reference and after this column I have month in row format and values which cannot be shared.
Hi everyone
I made a master calendar but the issue is it does not link it with the year of the master calender with the year of Gl year in the Invoice table and then I again created the year of the master calendar with the year of ordered date in the Order table. In the script, I just created the table but when I create the relation in the data manager it gives me this issue. I have separated the year from both tables in their tables also. I want my analysis to use GLdates year to show results so when I choose any year for example 2020 it shows pick the same year from the order date alos and show result.
This is my code in the load script.
// Create a master calendar based on GL_DATE
MasterCalendar:
LOAD
Date(GL_DATE) AS Date,
Year(GL_DATE) AS Year,
Month(GL_DATE) AS Month
Resident XX_INVOICE_GL_MV_TRIMMED;
I will be grateful if someone can help me fix it
Company name: Differentia Consulting
Company website: www.differentia.consulting
Job location: UK
Applications by: 31st December 2023
Start: Jan 2024
Full time role: YES
Job description:
Join the team that is helping to build Harmony for Qlik, the Qlik management and orchestration platform for Qlik Sense customers both on premise and Qlik Cloud.
If you are a computer software engineer/graduate interested in Analytics APIs Orchestration and would like to flex your software engineering muscle then let's have a chat to see if you would fit into our team. The role would also suit a Qlik Analyst that is technical enough to want to do the plumbing/integration and not the analytics.
Differentia Consulting has delivered more than 4,000 Qlik projects and services IRO 25k Qlik support tickets a year. With our acquired knowledge we want to help build a flexible interface (using APIs and Webhooks) to Manage and Orchestrate Qlik estates. The no code based solution can then be used to orchestrate operations inhouse by customer support teams, or remotely via managed service teams - without having to access Qlik environments.
The role of software engineer is a full time role and would suit a graduate with maximum of two years experience. The solution is already beyond MVP and looking for early adopters to trial it. During this phase we expect to add more Qlik api capability. Hence the need to hire quickly.
Please apply in writing to me with a covering note explaining why you would be ideal for the role. We can then have a chat. UK applicants only-sorry.
Email adrian.parker@differentia.consulting for further details
I want to make one filter which is YEAR and it should understand which column I'm talking about. For example, I have three files order, lines and invoice. The order and line file have the ordered date and the invoice has gl date. Now what I did was I extracted their years like Year(ordered date) name year 1 for the order file and year 2 for lines but they are extracted from the same field but different files because the ordered date is coming in order and line file but Gl date only comes in invoice file. I created year 3 from the invoice file which contains Gl's date.
In my analysis, I want to use GL date to see my results so I want the filter to understand if I select 2020 from Year 3 it should understand or pick from the ordered date the year 2022 and show me the results.
I applied this equation in my KPI chart to make it understand but doesnt work.
Count({$<[YEAR3]={"=GetCurrentSelections (YEAR2)"},[ORDER.FLOW_STATUS_CODE]={'AWAITING_SHIPPING'}>} [ORDER.FLOW_STATUS_CODE]).
I want to make a master calendar so when I choose Year as filter and choose 2022 it should pick results for that year from two tables and show.
I have two files called Invoice and Order and the common field between them is Order Number. It's Order_No in the invoice file and ORDER_NUMBER in the order file. I created their relationship with the data manager but I don't know how to make the master calendar and how to use it.
I extracted the year from GL_DATE from the invoice file and the year from ORDERED_DATE from the order file but for my analysis, I want to use GL_DATE year as my filter and it should automatically match with ORDERED_date year.
So, I will be grateful if someone can tell me how to do it in step by step.
Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on our Qlik Replicate. This month's topic talk is: Qlik Replicate Best Practices
Questions:
Resources:
Did we answer your question? Let us know by clicking the like button!
Click here to see video transcript
Hi
I want to know how to make a date picker which only works for one KPi and does not change the results for the rest of the KPIs or charts when I select a range.
I created this but it does not work and shows me zero
Count({<ORDER_TYPE={'Awaiting shipping'}, DATE_FIELD={"$(vSelectedDate)"}>} DISTINCT ORDER_NUMBER)
I have created a variable called vselecteddate and defined the value the same as my column "DATE_FIELD". I want this date picker to work on one KPI only and once I give a range it should show me orders in that range and when I unselect it should show all