Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are pleased to announce that the Qlik Replicate August 2021 service release (version 2021.5 SR3) is now available. This release includes support for Databricks on Google Cloud as a new target endpoint as well as support for PostgreSQL 13 as both a source and target endpoint.
More information on the exciting new features available in Qlik Compose and Enterprise Manager for August can be found here.
And more information on the other August 2021 client-managed releases can be found on the product innovation blog.
Hi,
I am wondering when I have a source lookup on a column in a table, then I also have a filter on the table. What comes first? Are the records filtered then the source lookup occurs? or does the source lookup occur then the rows are filtered?
Regards,
Mo
Hi Team ,
We are replicating data from SQL Server to Postgresql
For SQL Server we are using MS-CDC for real time replication. But its Capture job is getting failed with error
nested limit exceed 32.
Version for SQL server is 2017 standard edition.
Any solution or ideas is appreciated !!!
In March of 2024, Snowflake announced that Hybrid Tables are now in QA.
Will the Snowflake target endpoint connector be modified to support replicating data to Hybrid Tables as well as traditional Snowflake tables? Is this on the roadmap?
https://docs.snowflake.com/en/release-notes/2024/other/2024-03-05-hybrid-tables
https://docs.snowflake.com/en/release-notes/2024/other/2024-03-13-hybrid-tables
Hi Team,
I am getting below error when loading data in Qlik SAAS environment.
Your quota limit of 5120.0MB was exceeded. you loaded 10098.1 MB. Reduce your data within this application or buy additional capacity.
Please suggest a solution on this. Can you tell me some ways to reduce the data.
Thanks
Vishnu
Hi,
This is my first partipation in the Forum. I need some help with my app.
I have a master measure to count dengue cases from December 2022 to April 2023. The problem is that to filter the months I use a variable that contains the aggregation with an analysis set that filters the months, and I call it as a function with the year as a parameter (to be able to apply it to 2023/24) but with this I end up taking the months of the year that passed as a parameter, that is, if it is 2023 it takes: January, February, March, April and December, instead of taking : December (2022), January, February, March and April, that is, December is also 2023.
I tried to solve it by making a condition in my master measure so that when the month is December, I pass the previous year and the month of December as parameters, and if the month is any of the remaining months, I pass the current year and those months. I think it can work but when I spend several months as the 2nd parameter, it cuts off at the first comma it finds.
I give you a bit of the code of how I have proposed it. Notice for the abbreviations and names of variables, measures and dimensions are in Spanish
My master measure
if(Mes='Dic',${vCantCasos(2022,'Dic')},${vCantCasos(2023,${vSetMesesSinDi})})
The error
For i=1 to 3
if $(i)<2 then
//jump to next
end if;
//code xxxxxxx
//code yyyyyyyy
NEXT
Above is the requirement, if i=1, do nothing.
I know I can put the code xxxx/yyyyy into ELSE, any other workaround/solution?
How to do this? I tried NEXT, but I get runtime error.
Bom dia, pessoal
Preciso trazer, em uma tabela como dimensão de Competência (01/01/2024), valores dos últimos 12 meses baseado na competência da dimensão.
No gráfico abaixo, os números 2234 e 1334 são números da competência. Abaixo, está o número dos últimos 12 meses.
Existe alguma fórmula para ajustar isso?
Boa tarde, Estou tentando fazer uma comparação entre o período atual - período passado / período passado * 100, o objetivo é conseguir uma variação de vendas em %, por exemplo, em meu filtro estou comparando o mesmo período em anos diferentes Fevereiro de 2023 e Fevereiro de 2024
A EXPRESSÃO QUE ESTOU USANDO É:
( ( Sum({<Ano_DC={"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) - Sum({<Ano_DC={" $(VAnoAnterior)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) ) ) / Soma({<Ano_DC= {"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}> } TOTAL_ITEM_DC)
ENVIANDO AS VARIAVEIS
VAnoAtual_DC:
=MAX(Ano_DC)
VAnoAnterior:
=MAX(Ano_DC) -1
VMesAtual_DC:
=MAX(Mes_DC)
Hello,
Is there any way to chose the ledger format for a large report that I want to print directly from Qlik Sense? I want to avoid the action of loading the data in Excel. I noticed that when I want to have a PDF version, the document is like a photo, which mean, I cannot select the data...Is it because my administrator restricted me or Qlik Sense doesn't save any reports in PDF(not the printing version).
Thank you!
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
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!