I am having data at different levels,

Globe, Country, State Levels. I want to show values in a Pivot table with County, State as Rows Summary as Column and Value is the metric to show.

Sample file is given, i want to show the values in pivot table as expected. 

Under summary column we have 3 values - ANSTC, ANSIG are numbers and ANSGTER is the percentage (ratio of ANSTC/ANSIG)

How to achieve this, Country, State and Summary are not fixed. User May change positions of Dimensions from Row's to Columns and Columns to Row's.

Exploring MCP Servers with Claude Desktop: A New Frontier for Qlik Developers.

Hello Qlik Community!

I'm excited to share a proof-of-concept project that explores an emerging technology with significant potential for Qlik Cloud developers: Model Context Protocol (MCP) Servers integrated with Claude Desktop.

What Did We Build?

We integrated three MCP Servers into Claude Desktop to demonstrate how AI assistants can interact with our development ecosystem:

1. IPDF Agent - Qlik MCP Server Edition - Our custom-built server exposing Qlik Cloud API endpoints
2. Atlassian MCP Server - For seamless Confluence documentation access
3. Snowflake MCP Server - For direct database connectivity and queries

Why Should Qlik Developers Care?

MCP (Model Context Protocol) is Anthropic's open standard that allows AI assistants to securely connect to data sources and tools. For Qlik developers, this means:

• Natural language queries to your data warehouses
• Quick access to technical documentation without context switching
• Programmatic interaction with Qlik Cloud APIs through conversational AI
• Potential for AI-assisted app development, data modeling, and troubleshooting

The Art of Possible

This project demonstrates that we're not just keeping pace with emerging AI technologies - we're actively implementing them in the Qlik ecosystem. While this is a proof-of-concept, it opens the door to exciting possibilities for developer productivity and AI-enhanced analytics workflows.

Watch the Video: https://youtu.be/-mOx8OcU3sU 

I'd love to hear your thoughts! Have you experimented with MCP Servers or AI-assisted development tools? What use cases would be most valuable for your Qlik workflows?

Read more at: https://www.datavoyagers.net/post/qlik-cloud-development-with-claude-desktop-and-mcp-servers

Regards,

Mark Costa

Working with multiple calendars in Qlik can be tricky—but mastering it unlocks powerful insights across your data. In this session, you’ll learn how to manage and compare different date types such as order dates, ship dates, and invoice dates within the same app. We’ll explore how to create canonical date models, use link tables, and build visualizations that let you easily switch between calendar contexts. By the end, you’ll understand when and why to use multiple calendars and how to ensure your measures and trends stay accurate, consistent, and meaningful across every view.

Sample App and data attached below

Other helpful resources:

• Beginner Introduction to Set Analysis

Improved Master Calendar Script Template courtesy: Rob Wunderlich 
(source: https://qlikviewcookbook.com/2015/05/better-calendar-scripts/)

Note - here you would change OrderDate to CanonicalDate - as the .qvf shows.

MasterCalendar: 
Load 
 TempDate AS OrderDate, 
 week(TempDate) As Week, 
 Year(TempDate) As Year, 
 Month(TempDate) As Month, 
 Day(TempDate) As Day, 
 'Q' & ceil(month(TempDate) / 3) AS Quarter, 
 Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear, 
 WeekDay(TempDate) as WeekDay 
;

//=== Generate a temp table of dates === 
LOAD 
 date(mindate + IterNo()) AS TempDate
 ,maxdate // Used in InYearToDate() above, but not kept 
WHILE mindate + IterNo() <= maxdate;

//=== Get min/max dates from Field ===/
LOAD
 min(FieldValue('OrderDate', recno()))-1 as mindate,
 max(FieldValue('OrderDate', recno())) as maxdate
AUTOGENERATE FieldValueCount('OrderDate');

Note: The stream experienced reduced upload bandwidth at the start, resulting in brief pixelation and stuttering during screen sharing. The connection stabilized shortly after, and the stream quality improved for the remainder of the session.

Here we explore many, many ways you can filter and focus your data in Qlik Analytics — from classic interactive filters and smart search to new 2025 features like chart-level filters! We’ll cover set analysis, drill-down hierarchies, alternate states for comparative analysis, bookmarks, button actions, and even variable-driven inputs. Whether you’re cleaning up your visuals or narrowing your insights to key business metrics, you’ll see just how powerful Qlik’s filtering capabilities can be.

Sample App attached

Hi guys,

I've updatet to Sense Version November 2025 and now I'm getting the following message when using the extension "On-demand reporting":

"On-Demand reporting control is not supported in this environment"

Can anybody help me, how can I fix this??

Kindly regards

Chris

Hi All,

I am working on retrieving the audit trail log files from Qlik Replicate and Qlik Compose to obtain user details related to their last login. Does Qlik offer any API to directly fetch this information, or is there an alternative method to retrieve these details from Qlik Replicate and Compose?

Regards,
Sudhakar

Hi All,

I am currently migrating a dashboard from QlikView to Qlik Sense. In QlikView, I have 30 tables that share the same dimension columns, but each table has different expressions (measures).

I would like to know if it is possible in Qlik Sense to create a single table with the common dimensions, and have the expressions (measures) change dynamically based on user interaction—such as clicking a button or making a selection. Ideally, the table would update to show the selected expression without needing to create multiple tables.

If this is possible, could you please advise on the best approach to implement this in Qlik Sense? For example, can expressions be stored and triggered via buttons or drop-downs, and how would I set this up?

Thank you in advance for your help

Hello,

On the following bar chart, I would like to customize the label. Instead of displaying the value (e.g., 199), I’d like it to show the percentage share relative to the total.
However, I want the axis to remain unchanged.

Thank you in advance,

Kind regards,
Théo ATRAGIE.

Hi,

Monthly Tabular Reporting

I created one Tabular Reporting. The Reporting contains 2 tabs.

Tab A

Tab B

Tab A shows the Product A and Product B for the last month (Oct2025). To filter the last month I created Filter and applied over the Send Task.

Yearly Tabular Reporting

Now, I would like to show the complete data (from 01.01.2025 to today()) for Tab B with only Product A. How to do that ?

Problem: If I remove the filter then it will show the Tab A data from 01.01.2025 to today().

Simple: How to create Monthly and Yearly Report Sheets in a same .xlsx file?

Thanks

Hello
I have a dashboard in which there are 2 dimensions (fiscal year, and Movement) and these 2 dimensions are set to have Always One Value selected

Now I need to make comparative analysis in one of the sheets, so I created 3 alternate states to do comparative analysis based on selections made on fields in the 3 alternate states respectively
so far so good howver because the above 2 dimensions are set to have always one value selected the filter at the top appear as follows;

is there a way not to display alternate states but only teh default?