About Qlik Community

April Fools' Day is the favorite holiday of which animal? The silly goose! Happy April, everyone!

This month, we spotlight a Qlik Community member using the platform for 17 years. The statistics I'm about to share began in 2020 when he created a new profile. Since then, he has made almost 1,000 posts, solved hundreds of problems, and given and received countless likes. He's not only active in the forums, but he also belongs to like-minded Community groups. You may know him as QFabian. It's my pleasure to introduce our featured member for April, valued customer and Specialist III, Fabian Quezada. Here is his remarkable Qlik story in his own words.

During my free time, I like to observe the stars and planets within my reach and enjoy discovering the rings of Saturn and the colors of Jupiter. Then, I see all the data that is used and generated before and during the observation. With Qlik, everything is prepared for observation and discovery. Data and business rules are obtained and processed, and the results are graphed for analysis and discovery.

Qlik is an effective and proven way to deliver reliable data for decision-making in a friendly and intuitive interface in memory, and Qlik has been doing it for many years. Qlik's associative engine is unique and extraordinary. Whether you choose cloud, local, or hybrid, Qlik always delivers.

I have been a fan of the Qlik community for a long time. My current account isn't that old. I created the first one in 2007, but I lost it. Although many companies have community sites, Qlik is a pioneer in this regard, and the collaboration between Qlik personnel and the rest of the Community membership is impressive. Being part of the Community allows me to keep challenging my mind. I always try to provide quick and effective answers with detailed explanations and practical examples, just as I would like all cases I review to be when I seek to understand new concepts or encounter script challenges.

It's also important to note that being a member of the Qlik community makes me feel like I am part of something big. 

Let's show Fabian how much we appreciate his contributions to the Qlik Community by commenting and hitting that like button. @QFabian @Sue_Macaluso @Melissa_Potvin @nicole_ulloa @Jamie_Gregory 

If you missed the live Q&A session on April 10th, the recording is below. This session was all about asking questions about Qlik Connect.  Whether you are already registered or still considering attending, have a listen. This recording will be available until June 3, 2024. @Michael_Duval @abudd @Jamie_Gregory 

https://qlik.zoom.us/rec/share/tCOY6AEMRo1seYvDS0dZXEOtRyKGBqGCcmBi3tkeV3zTrBiDdDnBfY6Aqe5eSe4.OEkoaqdOfAkVasY7 
Passcode: 1*7lUD+= 

In the release notes section of Qlik Community there are filtering options above the list of posts. The filter "Products" does not work. When selecting a product the list updates, but whatever product I choose the result is just some kind of sorting where either NPrinting or QlikView ends up at the top.

Hello Everyone,
I have been learning Qlik Sense for 2 months, but now I'm having difficulties to create table in QS. 
I attached the header part of my table. How can I create the same header in Qlik Sense?

Thannk beforehand

HI,

I'm facing an issue where I can't find the snapshot option when selecting the filter pane visualization, unlike other visuals where it's readily available. Additionally, I require live data in the storytelling sheet and the ability to utilize filtered pane visuals within it.

We thought the Qlik Community could benefit from this information about how Generative AI promises to take us into a new era of productivity. Read all about it and sign up for the latest companion guide. 

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]).