Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 264,113 members
  • 5,447 online
  • 2,045,536 posts
  • 154,233 Solutions
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details

Welcome to Qlik Community

Trending Forums

Recent Discussions

  • forum

    Qlik Answers

    Qlik Pivot Table Custom Display of Values

    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... Show More

    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.

    MMK_0-1762882776184.png

     

    Show Less
  • forum

    Integration, Extension & APIs

    Qlik Cloud Development with Claude Desktop and MCP Servers [Video]

    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 tha... Show More

    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

    Show Less
  • forum

    Do More with Qlik

    Working with Multiple Calendars - Qlik Live Stream Ep 4

    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 t... Show More

    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:

    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');

     

    Show Less
  • forum

    Do More with Qlik

    Focusing and Filtering Your Data with Sample - Ep 3

    Note: The stream experienced reduced upload bandwidth at the start, resulting in brief pixelation and stuttering during screen sharing. The connection... Show More

    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

    Show Less
  • forum

    Integration, Extension & APIs

    Version November 2025 - error by Extension "On-demand reporting"

    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-Deman... Show More

    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

    Show Less
  • forum

    Qlik Compose

    Qlik Compose and Qlik Replicate api to fetch user login detail.

    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. D... Show More

    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

    Show Less
  • forum

    Visualization and Usability

    How to create a single Straight table should dynamically change with different m...

    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... Show More

    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

    Show Less
  • forum

    Reporting Service & Alerting

    Customize the Label of a Bar Chart – Pixel Perfect

    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... Show More

    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.

    Show Less
  • forum

    Reporting Service & Alerting

    Tabular Reporting Filter

    Hi,Monthly Tabular ReportingI created one Tabular Reporting. The Reporting contains 2 tabs.Tab ATab BTab A shows the Product A and Product B for the l... Show More

    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

    Show Less
  • forum

    App Development

    Hide alternate states for columns with always one value selected property set

    HelloI have a dashboard in which there are 2 dimensions (fiscal year, and Movement) and these 2 dimensions are set to have Always One Value selectedNo... Show More

    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;

    ali_hijazi_0-1762515370269.png


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

    Show Less

FREE TRIAL

Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!

Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image

Customer Story

Catalyst Cloud (Fusion)

Catalyst Cloud developed Fusion, a no-code portal that integrates with existing Qlik licenses to deliver critical insights across the organization. The results? Time savings, transparency, scalability to expand, and increased adoption.

Customer Story

Catalyst Cloud (Coeus SEP)

Catalyst Cloud developed Coeus SEP, a Qlik‑based platform for sharing supply chain data with suppliers.

Customer Story

Instant Answers Empower Thousands of Users

Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.

Customer Story

Empowering Students With Data Skills for Real-World Impact

Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Your Place, Your People

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

Did you know...

Catch the Latest from Qlik

The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?

Did you know...

Qlik Free Trials

You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.

Did you know...

Turn change into opportunity

Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.

Did you know...

Mastering Change Data Capture

You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.