Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I need to parse and load DB a pipe delimited file having data in the below structure using Talend.
Col1|Col2|Col3
"abc|111"|100|"zzz"
"xyz|222"|200|"yyy"
I am using dynamic schema as there are are multiple files with different schemas.(but all files follow the above rules).
Issue : It is note able to parse the entire content inside double quotes (abc|111) as single field.
Please help.
Thanks
Hello,
I'd like to know if there is any way for a user that doesn't know anything about Qlik Sense to show drastically the filters that they are in. To make a story short, I'm currently building an interactive report with buttons, so the user can clik on them, but I want to make it obvious for them to know in what filters they are in. I know that we have the filters all the way up of the page, but sometimes, it's not that obvious.
I don't know if I'm expressing myself clearly, for an exemple, on Amazon site we can see this tree :
The filters doesn't have to be like that, its just an example, but something of this kind...
Thank you!
Hi Qlik,
I want to ask about the specifications of Qlik Replicate Enterprise Manager Repository.
We use AWS PostgreSQL RDS as a repository. What are the minimum specifications?
Thank you.
Best regards,
Herra
let prevmon=date(addmonths(today(),-1),'MMM YYYY');
LOAD
"As of Date",
"xxxx",
"xxx",
"XXXX",
"XXXX"
FROM [lib://Source/SourceLanding/Reports/monthlyDetail report as of $(prevmon).xls]
(biff, embedded labels, table is [qry For Comments$]);
Good afternoon, I'm trying to make a comparison between the current period - past period / past period * 100. The goal is to obtain the variation in sales in %. For example, in my filter, I'm comparing the same period in different years: February 2023 and February 2024.
THE EXPRESSION I'M USING IS:
( ( 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)
VARs
VAnoAtual_DC:
=MAX(Ano_DC)
VAnoAnterior:
=MAX(Ano_DC) -1
VMesAtual_DC:
=MAX(Mes_DC)
Hi,
Recently we tried to upgrade our Qlik Sense from May 2023 to August 2023 (IR). The upgrade went well for DEV and QA servers. But it failed on production servers. We had to restore production servers with backed up AMI. Now we are investigating the reason why it failed. We have realized that we made a mistake when upgrading QS production which has two nodes: We stopped services on both nodes and then ran installation on two nodes at the same time. We know it is incorrect. But why did it cause problem? I am writing a report and need to gather deeper information.
Based on installation log files, I can tell the failure occurred at ServiceDispatcher step. Error occurred when it tried to create schema 'qlik_notifier_service'. I checked the log file for the successful installation on DEV server. When it tried to create schema 'qlik_notifier_service' there, it skipped this step because "Schema 'qlik_notifier_service' already exists" (the sentence in log). Why did the installation not skip it during production installation?
The attached ServiceDispatcher_installation_logs.txt contains related content from log files.
We need to make sure there is nothing else which caused installation failure. Please advise.
Thanks
Hi, I am currently working with Qliksense Desktop and I noticed that some cities in my country wouldn't get highlighted in the Area Layer in the Map object, even some smaller cities will be highlighted. Some weird things I noticed are that Qliksense did auto-generated the GeoInfo for the cities that are not highlighted in the data model viewer so I guess they were recognized by Qliksense right..? And also the Map Object will pin point all the cities just fine in the Point Layer but just not in the Area Layer. Just wondering is there any solution for that or this is some of the limitations of the Map object? Any help will be greatly appreciated!
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
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!