Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
国土数値情報の行政区域 第3.1版(令和4年、令和5年)の全国版をQVDにしました。
Zipで440MB程度あったファイルをSimplifyでポリゴンの頂点を簡略化し、12MB程度のファイルにしました。特定の行政区とデータを連携させて見る場合によいかもしれません。
https://nlftp.mlit.go.jp/ksj/gml/datalist/KsjTmplt-N03-v3_1.html
行政区域コード(N03_007)をキーにしてExcelファイルのマスタと紐づけると下図のように市区町村からの検索も可能です。
I am trying to create sales info for a customizable "Current Period" and "Prior Period" setup similar to what is in our company's ERP.
I used the same field INVOICE_DATE.autocalendar.YearMonth and created two filters with alternate states for each period.
While that does work on the surface, it feels really limiting because I cannot seem to filter down any dimension field. I am using a pivot table format, and I cannot seem to filter down to one specific customer or product family or sales rep or anything.
Is there a way around this, or is this just inherent to Alt States in QLIK?
THX!
Using Qlik Cloud and want to be able to globally change the default variable (not have to change it in every load script) for
Set DateFormat that auto populates the MAIN section in the Data Load Editor when creating new APPs.
Currently
SET DateFormat='D/MM/YYYY'
Preferred it to be
SET DateFormat='DD/MM/YYYY'
Also would prefer to change the FirstWeekDay
Currently we have to change this for every new APP that is created, but if one of our APP builders forget to change this we get different formats and first day of week in different APPs that impacts our users.
Hi,
Facing error "Failed to write record id: x, Number of values: y is not equal to number of columns: z" . When Qlik is reading the file and at the same time , file is being overwritten by another job.
So is there any setting in the replicate, to lock the file while reading by replicate.
Thanks.
Hi team,
Question is regarding passing Score of Certification exams. When I taken the Qlik Sense Business analyst certification-2022 exam( AUG-2023 )passing Score is 72% , Now in the official Website of Qlik https://www.qlik.com/us/services/training/certifications-and-qualifications/faqs Showing Passing Score is 62%.
It's Officially Changed , Please let me know , any one have taken QSBA2022 Exam Recently.
Thanks !!!!
i'm iterating over 20 databses that have 80% identical shema (slight changes in names, column) , i want my job to continue running in case there is error in tdbinput databse X (in case there is changes by user) , log the error , and continue the next target X+1 . i tried with componenet error and subjob error but it doesn"t work, the job die.
thanks.
Hi Support,
We have recently seen an issue where the Qlik Enterprise Manager service fails to start with the QEM logs indicating the following error:
"[ERROR] REPO-E-FACSQLREP, Failed to connect to SQLite repository 'C:\Program Files\Attunity\Enterprise Manager\data\rtdata.sqlite' "
We were able to resolve the issue by stopping the QEM service and renaming the rtdata.sqlite file to rtdata_old.sqlite, and then renaming the rtdata.new.sqlite file to rtdata.sqlite. After then running the command to upgrade the repository (aemctl.exe repository upgrade), the QEM service was able to run and the console could be accessed.
Previously when we have seen an issue with a data repository file it has been a result of memory or disk space issues on the server. However, in this case, there have been no reported memory/disk space issues on the server. What we'd like to understand is what are the possible reasons the rtdata.sqlite file becomes unreadable/corrupted.
This instance of Enterprise Manager is v2023.11.0.259
Thanks,
Nak
How do I keep two tables separately when uploaded? Each table is a separate Excel file (Feb.xls and March.xls). Row heading and columns are the same on both files except data are different (production numbers). I created a new App. Then uploaded two separate files. But both gets combined into one table once uploaded. Instead of seeing two Bubbles, I see one Bubble in Data manager (as shown below). I would like to see each table separately with two Bubbles in a Data Manager. One for Feb and one for March. Thank you.
Hi qlik community,
Could you please confirm whether we need separate licenses for configuring the high availability environments for Qlik Replicate, Talend (TAC + Job Server), and Qlik NPrinting?
Regards,
Nilesh
Hi,
I am wondering if it is possible to generate a diagnostics package that includes the task logs from the past 30 days, instead of the most recent log files.
Regards,
Mohammed
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.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
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!