Recent Discussions
-
Address not showing
Hi, I have a table with a large number of columns which includes an address (which is a full address from the data). One column shows the starting add... Show MoreHi,
I have a table with a large number of columns which includes an address (which is a full address from the data).
One column shows the starting address (so the from address) and another column showing the end address (so the to address). When I select an address from the "from" column, the address in the "to" column shows nothing, and vice versa.
Any help would be great,
Than you
-
creating individual qvds automatically for last 12 months per month wise
Hello Experts,I have Requirement to created the qvd on the month wise, As of the i have one historic qvd where all 12 months data got loaded and getti... Show MoreHello Experts,
I have Requirement to created the qvd on the month wise, As of the i have one historic qvd where all 12 months data got loaded and getting data loaded on incremental basis. however due to huge volume of data qvd is getting corrupted and creating problem so need to maintain the qvd's on month manner. like below
Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25
let's say today we are in April 2025, all this month is should load april month data and stored inot april month qvd. once April is passed extraction automatically creates may month qvd.
Also can you please assist me how do dynamic app titling based on the date data availability in app . eg: Sales jan_2024 , feb_2024
-
Qlik Cloud Storage and Resource Usage During Reloads
I have a couple of questions regarding Qlik Saas Capacity-based subscription:If we try to load more than 1 GB in our Personal space, will Qlik Cloud g... Show MoreI have a couple of questions regarding Qlik Saas Capacity-based subscription:
If we try to load more than 1 GB in our Personal space, will Qlik Cloud give us a message that this is not possible and stop the load, or will it load anything larger than 1 GB in a shared space automatically?
App peak reload size is sometimes much higher than the app size on disk—for example, when we have a row-based optimized load, we temporarily load up to 10 times more rows, or when we hold many temporary resident tables in memory during the reload process.
This increases RAM usage during the reload—is this counted in the daily usage?
Thanks!
Thanks!
-
How to resolve the error on not null constraints?
Hi,I have a new task trying to load the table but it failed to load successfully. Got an error on the following. How can I fix this in Snowflake as ta... Show MoreHi,
I have a new task trying to load the table but it failed to load successfully. Got an error on the following. How can I fix this in Snowflake as target endpoint?00006060: 2025-04-02T01:29:37 [TASK_MANAGER ]W: Table 'TSCHEMA'.'20TABLE' (subtask 0 thread 1) is suspended. A NOT NULL constraint violation occurred on column 'DO'.
After resolving the issue, check for additional NULLs that might violate NOT NULL constraints. Then reload the table. (replicationtask.c:3152) -
Conditions/guideline to select reload target
I am not familiar with Qlik Replicate and would like to seek professional advice. In case the tasks in Qlik Replicate failed and stopped. There are 2... Show MoreI am not familiar with Qlik Replicate and would like to seek professional advice.
In case the tasks in Qlik Replicate failed and stopped. There are 2 options:
1. Resume processing
2. Reload Target.
Which option should I select if the task is stopped due to error? Any guideline or reference to help to make the decision. For example, if the system returns several error codes, we must select "Reload Target". Or we can always select “Resume Processing” in the first attempt. If it fails, can then select “Reload Target” in second attempt. Or any other suggestions so that we can decide the next step after the task gets the error.
My main purpose is that I need to provide a guideline to the team members about failed case handling. If my team member encounters error and the task(s) is/are stopped, how can they respond based on the fact or data.
Thank you.
-
QlikSense Pivot Expand/Collapse
Hi, in QlikView's Pivot tables it was possible to expand/Collapse all for only certain dimensions but in QlikSense when I choose "collapse all" it clo... Show MoreHi, in QlikView's Pivot tables it was possible to expand/Collapse all for only certain dimensions but in QlikSense when I choose "collapse all" it closes the entire Pivot table. Is it not possible to just expand/collapse certain dimensions as in QV?
-
Task in QMC cannot be stopped
I tried to stop and disable task in QMC, but it will automatically start to run again.I also tried to delete TaskLoq from PublisherTemp\Tasks and rest... Show MoreI tried to stop and disable task in QMC, but it will automatically start to run again.
I also tried to delete TaskLoq from PublisherTemp\Tasks and restart server but it didn't help?
help please,
-
Straight table Top2 show
Hi , I have a flat table in qliksense as below. I am calculating the rate based on package number and country.What I want here is to show the 2 countr... Show MoreHi ,
I have a flat table in qliksense as below. I am calculating the rate based on package number and country.What I want here is to show the 2 countries with the highest rates based on a package number. How can I do this?
Dimesion1= [Packege Number]
Dimension2=Category
Dimension3=Country
Measure=sum(ERFMG)/sum(total<MATNR,MATNR_SIPNO,[Packege Number]> ERFMG)
I want to result.
Packege Number Category Country-Top1 Ratio %-Top1 Country-Top2 Ratio %-Top2
0010936761 Primer BAE 64,1% Hindistan 35,9%
0009736567 Primer Kazakistan 68,6% Malezya 18,7%
Thank you so much.
Best Regards
-
Capacity Based Analytics - Scenarios
Hello,We are considering the Capacity Based subscription plans for our clients and would like to clarify these two scenarios:#1:If, in the course of o... Show MoreHello,
We are considering the Capacity Based subscription plans for our clients and would like to clarify these two scenarios:
#1:If, in the course of one year, we consume 3 GB each month, will the total annual consumption be 3 GB or will it add up to 36 GB
#2: If we exceed our annual capacity (let's say 25 GB) in a single month by loading 27 GB, will we be charged only for the 2 GB overage, or will we need to pay for an additional 25 GB of storage? If the latter is the case, will this also grant us access to the additional features included in the larger package?
Thanks!
-
Configurazione SMTP Microsoft Office 365 Qlik Cloud
Buongiorno a tutti, sto configurando un server SMTP in un ambiente Cloud, l'SMTP è Office 365 e ho notato che è stata inserita una nuova sezione dedic... Show MoreBuongiorno a tutti,
sto configurando un server SMTP in un ambiente Cloud, l'SMTP è Office 365 e ho notato che è stata inserita una nuova sezione dedicata per configurarlo. Ho inserito l'ID del tenant, ID Client e Segreto Client (ovviamente sono corretti, generati e copiati direttamente). Ho impostato anche le API permission per Microsoft Graph come indicato qui
Quando salvo le impostazioni in Consolle mi viene mostrato l'errore "Credenziali Errate".
Per completezza aggiungo che è presente anche una configurazione SMTP normale (fino a poco fa non era presente quella dedicata ad Office 365) che non era funzionante pur essendo configurata esattamente come altre in altri ambienti funzionanti.
Qualcuno può aiutarmi?
Grazie mille