Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 241,061 members
  • 4,072 online
  • 2,023,840 posts
  • 152,203 Solutions
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY

Welcome to Qlik Community

Recent Discussions

  • forum

    Move to SaaS

    Data Transfer send to Data Folder

    Can Qlik Data Transfer send QVDs to subfolders in a space? 
  • forum

    Deployment & Management

    Setup Qlik server on new Domain.

    Hi All, We have Qlik Sense server running in old domain. We have taken the repository data base backup and installed Qlik Sense server on new domain. ... Show More

    Hi All,

    We have Qlik Sense server running in old domain. We have taken the repository data base backup and installed Qlik Sense server on new domain. After installation i applied the backup which we have taken from old server and restarted the Qlik server.

    I executed all command which i have listed below.

    cd "G:\Program Files\Qlik\Sense\Repository\PostgreSQL\14\bin"

    Run the following commands in order to drop and then create the database:

    Drop database (if one exists):

    dropdb.exe -h localhost -p 4432 -U postgres QSR​

    Create temp database:

    .\createdb.exe -h localhost -p 4432 -U postgres -T template0 QSR​

    Restore the database by running the following command:

    pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "<Path>\QSR_backup.tar"

    Start the Qlik Sense Service Dispatcher.

    cd "G:\Program Files\Qlik\Sense\Repository\

    Repository.exe -bootstrap -standalone -restorehostname

    After That when i am trying to open QMC its open but everything disabled

    jrathgebercs_0-1737022330648.png

     

    Could you please suggest me what need to do to enable everything.

    Note: In the new domain server. user directory table name will be different.

    Regarding,

    Irshad Ahmad

    Show Less
  • forum

    New to Qlik Analytics

    Calculating number of days for different actions in load script (or a better way...

    I have a set of data that looks like this: Name Date Action peter 1/1/2025 open paul 1/1/2025 close mary 1/1/2025 reject peter 1/2/2025 ope... Show More

    I have a set of data that looks like this:

    Name Date Action
    peter 1/1/2025 open
    paul 1/1/2025 close
    mary 1/1/2025 reject
    peter 1/2/2025 open
    paul 1/3/2025 close
    mary 1/4/2025 reject
    peter 1/5/2025 reject
    paul 1/6/2025 open
    mary 1/7/2025 close
    peter 1/8/2025 open
    paul 1/9/2025 close
    mary 1/10/2025 reject

     

    I want to have results that look like this:

    Name Date Action results
    peter 1/1/2025 open 0
    paul 1/1/2025 close 0
    mary 1/1/2025 reject 0
    peter 1/2/2025 open 1
    paul 1/3/2025 close 2
    mary 1/4/2025 reject 3
    peter 1/5/2025 reject 0
    paul 1/6/2025 open 0
    mary 1/7/2025 close 0
    peter 1/8/2025 open 6
    paul 1/9/2025 close 6
    mary 1/10/2025 reject 6

     

    I've been trying to do it with concatenated fields, nested IF statements and multiple variables and I'm having no luck getting the syntaxes correct to do so, and it is making the script way too complicated to be readable. 

    The results are just the number of days since the named person has performed a particular action.

    I could probably do this in Excel or a Python/PowerShell script prior to loading the data but I'd really like to understand how it can be done with the data load script. In my real data I have about 500 Names and a dozen or so actions, but I don't believe that will matter to the solution.

    Show Less
  • forum

    App Development

    Please help me change default selection colors. Nothing works!

    Why in all of creation does this not work at all!?https://qlik.dev/extend/create-custom-themes/custom-themes-basic-examples/#example---app-selections ... Show More

    Why in all of creation does this not work at all!?
    https://qlik.dev/extend/create-custom-themes/custom-themes-basic-examples/#example---app-selections

    It should not be this hard to set a global default for selected, alternative, excluded etc. The code samples from the above link do nothing. I know I'm testing updated files because I can see title text change. I refuse to edit every single filterpane. 
    From a CSS angle, the selection appears to use the class .RowColumn-S which I can override by winning on specificity but it feels like a hack especially since the docs are clearly stating that I should be able to do this in theme.json.

    Please clear this up for me.

    Show Less
  • forum

    App Development

    Bar chart to show only 12 months rolling

    Hi team,   attached  is my sample data which have  fact and master calendar  and below  is my script and chart expression Fact:LOADMeasurefield,date(f... Show More

    Hi team,

     

    attached  is my sample data which have  fact and master calendar  and below  is my script and chart expression

    Fact:
    LOAD
    Measurefield,
    date(floor(num(Date))) as Date,
    Fact_flag
    FROM folder;

    Dim_MC:
    LOAD
    date(floor(num(Date))) as Date,
    WEEK(Date) AS Week,
    YEAR(Date) AS Year,
    MONTH(Date) AS Month,
    DAY(Date) AS Day,
    WEEKDAY(Date) AS Weekday,
    'Q'& CEIL (MONTH( Date ) / 3 ) AS Quarter,
    DATE(monthstart( Date ), 'MMM-YYYY') AS MonthYear,
    WEEK(Date ) & '-'& YEAR (Date ) AS WeekYear

    from folder;

     

    bar chart dim and exp

    dim as month year

    exp as below

    if(GetSelectedCount(Year)>=1 or GetSelectedCount(Quarter)>=1 or GetSelectedCount(MonthYear)>=1 or GetSelectedCount(Week)>=1 or GetSelectedCount(Date)>=1,

    Sum({<Fact_flag={'fact_1'}>}Measurefield),

    Sum({<Fact_flag={'fact_1'},
    MonthYear = {">=$(=date(MonthStart(AddMonths(Today(), -12)),'MMM-YYYY'))<=$(=date(MonthEnd(AddMonths(Today(), -1)),'MMM-YYYY'))"}>}Measurefield)


    )

    i want to show the default 12 months rolling in my chart and i don't want to disable the data enabling ->  include zero values, because if there is no data for that month it have show 0 for the month since i am using master calender

    now wht is happening in bar chart it shows entire all months here, it have to show only 12 months data as per the if loop section 

     note i dont want to disable the data handling  -->include zero values please help and support on this and also no calculated dim also 

    manoranjan_321988_0-1732808755438.png

     

     

     

    Show Less
  • forum

    App Development

    rolling 6/4 months in bar /pivot table with multiple or 2 diemsnion

    Hi Team,   PFA  of my sample data and QVF, I want to show the rolling 6 months data as default with monthyear dim and if there is no data for the roll... Show More

    Hi Team,

     

    PFA  of my sample data and QVF, I want to show the rolling 6 months data as default with monthyear dim and if there is no data for the rolling months it has to show zero in the bar chart and  if user select any timeframe monthyear  dim has to be changed accordingly as per the selected timeframe example week or year or date, All these are achieved.

    now the issue is if i add another dim in the chart and disable the include null value , i am not getting the zero value. bar chart has to  show allways rolling 6 bars, if no data then it shd be zero and similarly pivot shd show the rolling 4 months.

    manoranjan_321988_0-1737139703982.png

     

     

    Show Less
  • forum

    Alerting

    Customize Email Alerts

    Does anyone know if it's possible to customize the emails sent for Alerts? Specifically, I want to remove anything that mentions Qlik (images, text, s... Show More

    Does anyone know if it's possible to customize the emails sent for Alerts? Specifically, I want to remove anything that mentions Qlik (images, text, sender name, etc.) and only keep the title of the alert and the data that caused it to trigger.

    Qlik Alerting 

     

    Show Less
  • forum

    Qlik Reporting Service

    PixelPerfect reporting and beyond!

    With the turn of the calendar, it's a great time to recap the exciting reporting updates from 2024 and look forward to 2025 and the continued expansio... Show More

    With the turn of the calendar, it's a great time to recap the exciting reporting updates from 2024 and look forward to 2025 and the continued expansion of reporting capabilities on Qlik Cloud Analytics.  

    We packed 2024 with enhancements in reporting capabilities, featuring sought-after additions to both enterprise reporting and interactive distributions.  

    Quick recap: 

    • Dynamic Subscriptions: Subscriptions can now utilize dynamic expressions, and users can preview them. You can perform an ad hoc multi-sheet download, and if you like it, you can schedule it for future delivery. 
    • On-Demand Reports: Report developers can make Tabular or PixelPerfect reports available on-demand within an app, allowing users to set their selections and download reports immediately.  
    • Cycling Feature: Developers have increased control with the addition of cycling (repeating a report per dimension) within task configurations. 
    • Task History: Developers can now see up to 90 days of report task execution history. 
    • PDF Output: PDF output for Tabular reporting has been introduced. 
    • Integrated PixelPerfect Editor: An in-app integrated PixelPerfect report editor is now available, enabling users to create visually stunning, highly customized reports with pixel-level precision. Reminder - Developers can enhance their editing skills through a free e-learning module. 
       

    For details on the 2024 releases, check out the "What's New" section and filter on Analytics > Reporting and Alerting. 

    Reporting from Qlik Cloud Analytics on the help site should be your starting point for understanding the power and flexibility of reporting on Qlik Cloud Analytics.  Take the time to review it in detail, it is very comprehensive!

     

    Looking ahead to 2025* 

    Work is already underway on some exciting capabilities: 

    • New Report Authoring Tools: In addition to PixelPerfect, an embedded in-app HTML editor is in development to support authoring of HTML report templates. These templates can serve as the email body for task distributions when using the email channel; HTML attachments will also be supported. 
    • Multi-Template Distribution: The report task will expand to allow multi-template report distribution. Developers will manage tasks that include HTML report bodies and attachments for Tabular, PixelPerfect, and HTML templates. 
    • Enhanced Reporting Guardrails: We will also expand some of our reporting guardrails in line with customer reporting growth. 
    • New Straight Table - download column totals: The new straight table is getting a boost with some ad hoc download controls including the inclusion of column totals.  
       

    We are also investigating other areas of customer feedback, such as dynamic filter import, and dynamic filename definition. Please continue sharing your ideas on our community ideation portal - the status of reporting topics in ideation is up to date as of this post.  Stay tuned and start planning for Qlik Connect!!! 

     

    *Disclaimer: This post includes Qlik® roadmaps statements to provide a general overview of our anticipated product direction as of the date hereof. Qlik undertakes no intention or obligation to update or revise any forward-looking statements contained herein, whether as a result of new information, future events or otherwise.  

    Show Less
  • forum

    Integration, Extension & APIs

    Qlik Cloud map extension that can handle >100K points?

    Does anyone know of a Qlik Cloud map extension, open source or paid, that can handle over 100K points? The built-in map seems to have a limit of about... Show More

    Does anyone know of a Qlik Cloud map extension, open source or paid, that can handle over 100K points? The built-in map seems to have a limit of about 4K points.

    Show Less
  • forum

    Qlik Reporting Service

    Applying a filter to a chart - Tabular report

    Hello, Our company is in the process of moving to Qlik Cloud. We are in the process of migrating Nprinting reports to the cloud, mainly tabular report... Show More

    Hello,

    Our company is in the process of moving to Qlik Cloud. We are in the process of migrating Nprinting reports to the cloud, mainly tabular reports, as they are based on Excel models.

    On some reports, we are encountering migration problems. For example, we are applying a filter on a line graph for data from a specific week (filter CSL_Last_Week_Actual_Year on graph <wyEBjY>, screenshot below of Nprinting design).

    florian63_0-1737102933615.png

    When I export this Nprinting template to a tabular report template (with "Export Qlik Cloud reports" on Qlik Nprinting web console), I get an error because this functionality is not available in tabular reports : "Object filters are not supported. The following tags will not be filtered"

    florian63_1-1737103931556.png

     

    How can I apply a specific filter to a specific graph on Qlik Cloud Reporting? With tabular reports, Pixelperfect, automation, etc...

     

    Thanks,

    Florian

    Qlik NPrinting 

    Qlik Cloud 

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

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.

Location and Language Groups

Choose a Group

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

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

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

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!