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
I need advice on what to do to resolve this.
Please help. Thank you
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);
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 |
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.
=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)
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?
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:
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.
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)" .
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.
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,
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, 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.
please help me
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.
Join other data diehards for 2.5 days of the hottest topics in data, analytics, and AI. Register now: June 3-5 in Orlando, FL.
If you are a customer, it's time to apply to be a Qlik Luminary. Applications are open through December 15.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Real-time Responses Delight Burgan Bank's Customers.
Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!