Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Watch this 2 minute video and get acquainted with all you can do on Qlik Community.
Hang out in the Community Corner for casual conversation and good information.
Qlik Community MVPs go above and beyond. Find out who is a Qlik Community MVP.
In our monthly ‘Round of Applause’ we showcase our shining stars on Qlik Community.
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
If you are new to the Qlik Community or are just looking for a How-To, below is a directory with direct links to some helpful articles:
Also, check out the Help page.
The attached White Paper is a guide for all our Community members on things TO do in the Qlik Community and things NOT to do. Please be sure to give it a read. If you have any questions, please let us know.
Happy May everyone! Believe it or not, this month is our 12th edition of Round of Applause! Even though it’s a cool name, we wanted an even cooler name for our featured members so from here on in we are going with High Five! This Community member has over 20K posts, received more than 8k likes, answered over 4K questions, and is a well-known leader in the Qlik Community. Today’s High Five goes to no other than Community MVP, Gysbert Wassenaar.
Gysbert joined the Qlik Community in September 2012. He had been visiting for a while, looking for answers to Qlik challenges he encountered in his job. He was already impressed by the quality of the answers he saw and by Community members who gave great solutions and advice. Gysbert was also impressed that Qlik employees participated actively. The day he decided to join the Community was when he saw a question from a community member and thought: "Hey, I think I know the answer to that." It was then he started participating, and he became hooked! Gysbert said he’s never learned so much so quickly about a product. Every question posted was another opportunity to expand his knowledge and Qlik skills. Three months later, he was a Top 5 contributor. He recalls passing Stefan Wühl as top contributor about a year after he joined. The feedback from other community members, and especially from Qlik Community legends like Deepak Vadithala, Stefan Wühl, John Witherspoon, Miguel Angel Baeyens, Henric Cronström, Rob Wunderlich, Marcus Sommer and so many more, was awesome and a big motivating factor to keep coming back to the Qlik Community.
In his personal life, Gysbert is very fortunate to be living in a small beautiful medieval city in the Netherlands. He likes reading, taking walks in the countryside, learning about new technologies, and learning new tricks he can apply in his job.
Let’s give a big “High Five” to Gysbert with a like and a comment to show how much we appreciate his collaboration in the Qlik Community. @Gysbert_Wassenaar @Melissa_Potvin @marcus_sommer @rwunderlich @hic@Miguel_Angel_Baeyens @swuehl @johnw @IAMDV
It’s hard to believe we’re in the last month of the year already. Our “Round of Applause” has definitely been a bright spot for us. Celebrating our most prolific and impactful contributors to the Qlik Community has been personally gratifying – and exciting for the rest of our Customer and Community teams. It’s with great pleasure that we introduce to you the final 2020 recipient of Round of Applause: Tresesco, a Qlik Community member so famous that he goes by one, well-known name.
Tresesco Biswas has 12.5K posts, and over 6K likes to his name. Consuming more than 61K posts, Tresesco has helped countless Community members get answers to their questions since 2010. You can find Tresesco Biswas active in the Qlik Community nearly every day.
Tresesco was pursuing his career in the IT industry when he was introduced to the language C. In 2010 he was introduced to QlikView and never looked back. He told us that Qlik has given him so many things in his life. He loves spending time in the Community helping others, learning new aspects of Qlik technologies, and the great people he learns from.
Tresesco currently lives in Bangalore India. He has a great interest in understanding human psychology and studies it on his own time. He enjoys traveling to places with natural beauty.
We are so delighted to have Tresesco as a key member of the Qlik Community. Please join us in recognizing him with a “Round of Applause” by leaving a comment and giving a like to show Tresesco how much we appreciate him!
See you next year!
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
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.
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
Hi guys,
I want my images to display dynamically
For eg:- If i click india it should display indian flag and if i click canada it should display canada flag currently I am using qlik sense 2020 version and mediabox extension not working
Kindly check and reply asap as because its an urgent requirement for my client.
Hi Guys,
I want my qlik sense bar chart labels to bold, I am currently using qlik sense version feb 2020 patch I have even attached the image.
Kindly check and reply asap because its little urgent.
I want to know I have two columns Order fufillment and Order request. These both contain date and time in this format (mm/dd/yyyy hh:mm:ss).
I want to know if I want to show average order processing time how can I do that and want to show in form of minutes: ss like ( 2.30 which is 2 minutes and 30 seconds) or hh:mm:ss. I want to show only for orders which have flag sign C.
Hello everyone,
I'm trying to include a graphic with alternate state in it. I choose a value in filters that have the same state then generate an on demand report. However it doesnt work correctly and the outcome doesnt take into consideration the Alternate state.
Is this an NPrinting limitation ? Or is there a solution /parameter to fix it ?
Thank you in advance,
Dounia ABAD
What is the meaning of "Error Code: 1021605"
Task "XXXX" on Replicate server "XXXX" has encountered error 1021605.
Details:
Task: XXXX
Server Name: PRD Oracle Sources
Host: XXXX
When: 02/20/2024 08:05:55 GMT-06:00
Source: XXXX - qlik_user (Oracle)
Target: XXXX - XS (Snowflake on XXXX)
Error Code: 1021605 <<<<<<<<<<<<<<<<<<<<<< What does this mean?
Error details: The task stopped abnormally
*******************************************************
This is an automated message sent by Qlik Enterprise Manager.
Hi guys,
I have a data with two column as date and other column as value but when I filter first column date I need to get that sum and when I filter second column date I need to get the sum of that with respect to column names. So the Kpi needs to work as a optional either this sum or that sum. Please check and reply asap.
I want to add in my bar graph that give option to the person to see result byt top 10,20,30,40 however he like please suggest how can I do. i know in filter we can limit once but I want to know how to do multiple in one graph?
I want to know can make this type of filter in Qliksense. When we have to use it appears and when we select the options we want to see and then close it it shows us the result and it has the option of applying all and reset and going back to default one. As shown in the example below