Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 180,640 members
  • 2,653 online
  • 1,803,160 posts
  • 138,131 Solutions
Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Failed to update database "DatabaseName" because the database is read-only

    Dear team, We have encountered this error suddenly a few hours ago, and only one replication task is experiencing this issue with the same target (Azu... Show More

    Dear team,

    We have encountered this error suddenly a few hours ago, and only one replication task is experiencing this issue with the same target (Azure SQL Managed Instance). The database is still functioning normally with other tasks, but only this one is affected.

    Failed to update database "FLXXX" because the database is read-only

    BC2_0-1701512996142.png

    I need advice on what to do to resolve this. 

    Please help. Thank you

    Show Less
  • forum

    Move to SaaS

    Is it possible to use web ticketing in Qlik sense cloud?

    As the title says, I would like to learn how to use web ticketing with Qlik sense cloud.
  • forum

    Qlik Cloud Data Integration

    Simple data range question

    Hi guys,   i'm stucking ni this simple situation where i need ta have bars from a date range (2014-now) but not all date have data in them, how do i g... Show More

    Hi guys,

     

    i'm stucking ni this simple situation where i need ta have bars from a date range (2014-now) but not all date have data in them, how do i generate a local autogenareted table with a date range?

     

    in Oracle i would do someting like this:

     

    SELECT

    (to_date(sysdate,'DD-MM-YYYY') - level + 1) AS day

    FROM

    dual

    CONNECT BY LEVEL <= (to_date(sysdate,'DD-MM-YYYY') - to_date('01-01-2014','DD-MM-YYYY') + 1);

    Show Less
  • forum

    App Development

    peek - previus ??

    Hello, I need to calculate the new value of the cell, but I am not able to make it work, can you help me?     A B C D E F       1 ID Fecha aument... Show More

    Hello, I need to calculate the new value of the cell, but I am not able to make it work, can you help me?

     

      A B C D E F      
    1 ID Fecha aumento Nombre previo_incremento Incremento Indice Cemep      
    2 40 1/2/2019 ASOCIART ART  9,9  20,0  120,0      
    3 41 1/9/2019 ASOCIART ART  20,0  15,0  0,0 calculate F2+F2*E3/100
    4 42 1/4/2020 ASOCIART ART  15,0  20,0  0,0      
    5 43 1/10/2020 ASOCIART ART  20,0  20,0  0,0      
    6 44 1/6/2021 ASOCIART ART  20,0  20,0  0,0      
    7 45 1/9/2021 ASOCIART ART  20,0  25,0  0,0      
    8 46 1/3/2022 ASOCIART ART  25,0  15,0  0,0      
    9 47 1/8/2022 ASOCIART ART  15,0  20,0  0,0      
    10 48 1/11/2022 ASOCIART ART  20,0  15,0  0,0      
    11 49 1/12/2022 ASOCIART ART  15,0  15,0  0,0      
    12 50 1/3/2023 ASOCIART ART  15,0  25,0  0,0      
    13 51 1/7/2023 ASOCIART ART  25,0  25,0  0,0      
    14 52 1/10/2023 ASOCIART ART  25,0  25,0  0,0      
    Show Less
  • forum

    Qlik Enterprise Manager

    Deleting Unused applications and tasks

    Hi Team, A common issue which every organization is facing is applications which are holding memory which are unused and unpublished in the work strea... Show More

    Hi Team,

    A common issue which every organization is facing is applications which are holding memory which are unused and unpublished in the work stream, and also the task which user is creating and not deleting once the work is completed, could you please suggest how to delete these.

    I should delete the unused apps which is not modified in the last 30 days and not published, and also the task, which is pointing to that application, And the QVD's related to that application.

    I think it would be really useful to those who are all managing QMC and every time ask the user to delete those, instead is it possible to create an application which runs on a particular period, and it automatically detects apps and delete it.

    Show Less
  • forum

    New to Qlik Sense

    Not able to understand this logic.

    =Sum({$<PAID={1,2},FISCAL_MONTH=,FISCAL_YEAR=,QTR_NAME=,PARENT_FISCAL_MONTH={">=$(=date(addmonths(max({<PAID={1,2}>}Date#(PARENT_FISCAL_MONTH,'YYYYMM'... Show More

    =Sum({$<PAID={1,2},FISCAL_MONTH=,FISCAL_YEAR=,QTR_NAME=,
    PARENT_FISCAL_MONTH={">=$(=date(addmonths(max({<PAID={1,2}>}Date#(PARENT_FISCAL_MONTH,'YYYYMM')),-12),'YYYYMM'))
    <=$(=date(max({<PAID={1,2}>}Date#(PARENT_FISCAL_MONTH,'YYYYMM')),'YYYYMM'))"} >}DISCOUNT_TAKEN_USD_AMOUNT)

    Show Less
  • forum

    Deployment & Management

    Windows update works

    Windows Server was updated from model 2012 to 2016 and the services below did not go up from the backup to the server after the update and so Qlik is ... Show More

    Windows Server was updated from model 2012 to 2016 and the services below did not go up from the backup to the server after the update and so Qlik is not opening from the server.

    Qlik logging service
    Qlik sense engine service
    Qlik sense Plinting service
    Qlik sense proxy service
    Qlik sense repository database
    Qlik sense repository service
    Qlik sense Scheduler service
    Qlik sense service dispatcher

     

    Does anyone know the reason for this error?

    Show Less
  • forum

    Qlik Replicate

    LOB column not replicated to csv file

    Hi, We recently encountered an issue with our Replicate task, where the source is a "SQL Server" and the target is a "csv file." During the generation... Show More

    Hi,

    We recently encountered an issue with our Replicate task, where the source is a "SQL Server" and the target is a "csv file." During the generation of the CSV file, we noticed that certain columns were missing. Upon further analysis, we identified that these missing columns were LOB columns, and the "LOB replication option" was not enabled in our replicate task.

    To address this, we are consider enabling the "Replicate LOB columns" option. However, we have a few questions and need your guidance on the following:

    1. How to check the LOB size in the source table?

      We would like to understand how we can determine the size of LOB columns in the source SQL Server table.

    2. How to decide the "Replicate LOB columns" option?

      We need your inputs on determining whether we should go with "Allow unlimited LOB size" or "Limit LOB size to (KB)" .

    3. If we select "Allow unlimited LOB size," how should we calculate and provide the chunk size?

      For the scenario where we choose to "Allow unlimited LOB size," we would like to know how to calculate and specify the chunk size.

    4. If we select "Limit LOB size to (KB)," how can we calculate and provide the value?

      In the case of selecting "Limit LOB size to (KB)," we need guidance on how to calculate and set an appropriate value.

    If possible, we are also interested in any SQL queries that can assist in gathering the necessary information.

    Thanks,

    Show Less
  • forum

    QlikView Administration

    I want to add color to a bar graph.

    I want to add color to the bar graph by entering the Expression background color. The conditions are If the bar graph shows data for the year, includ... Show More

    I want to add color to the bar graph by entering the Expression background color.

    Paknanarn23_0-1701498236465.png

    The conditions are If the bar graph shows data for the year, include rgb(30,144,255) and if the graph shows data for the month, enter Rgb(70,130,180) and if the graph shows data for the day, enter rgb(135,206,250)

    This is the code that displays the data in a bar graph.

    Paknanarn23_1-1701498358632.png

    please help me

    Show Less
  • forum

    New to Qlik Sense

    Num() Formating

    Hello Qlik world. I am trying to understand what the purpose of dec_sep & the thou_sep is in the function syntax: Num(number[, format[, dec_sep [, tho... Show More

    Hello Qlik world. I am trying to understand what the purpose of dec_sep & the thou_sep is in the function syntax: Num(number[, format[, dec_sep [, thou_sep]]]). I have looked everywhere and cannot find where it is clearly explained. Thanks in advance.

    Show Less
Leaderboard

Customer Story

New Data Integration Customer Story + Video

Real-time Responses Delight Burgan Bank's Customers.

Customer Story

Talking Analytics to the Frontier

Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.

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!