Hi,

I'm on my initial steps with Qlik Sense on my windows machine.

I've logged-in to the QMC and hub, opened an app and loaded the data- but when I try to go over to the sheet- it shows me a blank page.

Hello,

I have a scenario to calculate Age in years from DOB which I am doing using Age(Today(),DOB). The oracle source date format is 'DD-MMM-YY' & datatype is NVARCHAR2(100). 

While using Age(Today(),DOB) expression I am able to get correct years except DOB dates below 01-JAN-73 as qliksense is reading 73(YY) as 2073 and same for 72,71,70 etc as 2072,2071,2070 because of which is showing in negative like -49,-48 so on..

I tried to fix date format within qliksense hence the format is changing but year issue is still there and tried below logics:

1- Date format: date(date#(DOB,'DD-MMM-YY'),'DD/MM/YYYY')   AS DOB_NEW 

2- Date format_2: date(date#(DOB,'DD-MMM-YY'),'M/D/YYYY')   AS DOB_NEW2  

3- IF (Date format: date(date#(DOB,'DD-MMM-YY'),'DD/MM/YYYY') > '01/01/2026' , 

date(date#(DOB,'DD-MMM-YY'),'DD/MM/19YY') , date(date#(DOB,'DD-MMM-YY'),'DD/MM/YYYY')   ) (Logic - to fix the year issue but still dates below 01-JAN-73 showing years as 2073 which should be 1973)

Appreciate community support.

@hic @sunny_talwar @tresesco @Miguel_Angel_Baeyens @swuehl @maxgro 

Our October feature shines on Robert Mika, whose curiosity and design sense have shaped Community conversations. He’s the kind of contributor who makes complex topics feel approachable and enjoyable. From his first steps with Qlik in 2013 to becoming an active voice in the Community since 2014, Robert Mika’s journey has been defined by curiosity, creativity, and a drive to help others see the story in their data. Today, he works as a Creative BI Designer and Qlik Specialist.

Robert’s professional path has taken him across industries, from pharma and manufacturing to banking, insurance, and now technology. Along the way, he has shared his expertise generously in the Qlik Community, which he describes as a space where discovery thrives.

“Whether I’m solving technical challenges, exploring design ideas, or learning from others, I find inspiration in the creativity here,” Robert shares.

Outside of work, Robert finds balance in new age music, yoga, and the gym, practices that fuel his energy and help him recharge. It’s this mix of focus, creativity, and collaboration that makes his presence in the Qlik Community so impactful.

Robert, thank you for bringing your passion, creativity, and collaborative spirit to the Qlik Community. Please join us in celebrating Robert in the comments below!

@robert_mika @Sue_Macaluso @Melissa_Potvin @Jamie_Gregory @nicole_ulloa @Tammy_Milsom @Brett_Cunningham

Hi everyone,

I would like to ask if it is possible to create a visualization in Qlik Sense similar to the one in the attached example. The idea is to build a financial dashboard that shows a balance sheet layout, with Assets on the left side and Liabilities/Equity on the right side, aligned and structured just like in a traditional financial statement.

The goal is not only to display the totals, but also to present the hierarchy (e.g. Fixed Assets, Current Assets, Equity, Liabilities, etc.) in a mirror-style balance layout, instead of just a pivot table or straight table.

Has anyone tried something like this before?

• Are there extensions or best practices for designing such layouts in Qlik Sense?

• Would this require a custom extension, or can it be achieved with native objects and some creative formatting?

Thanks in advance for your advice!

Dear Qlik Community

We are using an approach very similar to the one described in this post to make our app multilingual.

However, we found that this drastically decreases the performance of dashboards up to a factor of 2-3. E.g. a dashboard with a table with 30 columns would load in 4 seconds without translation of the column titles. Adding translations increases load time to about 12 seconds.

We use the following expressions in the label:

=only({<[Language.Code]= {'Street'}>} Language.Text_$(v_Language))

=only({<[Language.Code]= {'City'}>} Language.Text_$(v_Language))

We set the language in the variable v_Language which then determines which column is used, e.g. Language.Text_EN, Language.Text_DE etc. Our datamodel is quite complex with almost 2000 fields (we are trying to improve that), but I would not expect this to be a problem for the translation. As in the linked post, our Language table is an island table.

Does anyone have an idea why this performance decrease happens and how it could be fixed?

Hi,

we have a source with ODBC connection to AS400. Connection is working fine but the problem is... unable to see the system catalog views SYSTABLES and SYSCOLUMNS accessible . Could you please advise how we can proceed

Qlik Observability Suite MCP

Differentia Consulting is proud to announce Qlik Observability Suite MCP Server embedded either natively into Claude (+ others) or via Chrome Extension (MCP SuperAssistant for Grok and live voice chat).

Chrome MCP Extension is live in Grok.

Voice-only audit: found stale apps, orphaned licenses, duplicate IDs, expired keys—all fixed in 8 minutes, no clicks. Listen as Ara performs a Qlik System Audit in seconds

Just one of the fun things to talk to us about at Differentia Consulting’s Qlik Customer Day, 9th Nov 2025.
Details at https://www.differentia.consulting/event/qlik-customer-day-9th-october-2025

How does it work?
1 Create MCP folder on local machine for services to operate

2 Deploy MCP services on local machine

3 Create Qlik API MCP Server - Qlik Observability Suite

4 Create API Key from Qlik Cloud

5 Load MCP Server into your AI interface of choice

6 Start a voice chat and be amazed at how slick Ara (Grok) is at managing your Qlik estate.

What we have is a working prototype over a demo Qlik Tenant, and it performs incredibly efficiently. In fact it is too quick. I am not used to real time answers, but that is what you get. 

Currently these are the APIs being accessed. (Note: For ultimate experience give the user Audit role in Qlik Cloud).

Note: In ten days I have gone from knowing nothing about MCP servers to having built tools to take AI from being dull, to a force of nature. I have delivered more capability in a week than in years. We built Harmony and Symphony to manage Qlik estates using a line of business application using Cyferd. MCP automation sits above this and gives you the ability to manage at a whole new level. Both relevant, both have their place. MCP based tools are happening everywhere and productionising them is going to be an really interesting process. But what they do mean is that the role of a data engineer is changed for ever.

I said tools plural, that is because we are also demonstrating how Qlik can show our Website Knowledge Graphs that can then be integrated into NLWeb and other MCP based platforms. All really exciting as NLWeb alters the internet from being passive to active. Enabling website to interact via AI Assistants.