Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
It seems to me that even at the present moment (May 2024) there is no AI model specifically trained to write Qlik script code, using the best of todays AI technology.
Of all the (limited) test I did, ChatGPT 3-5/4.0 seems to have some capabilities. Late edit: with GPT-4o from OpenAI just launched yesterday, things might have improved even more on OpenAI side.
From the open source AI models, Google Gemini or LLama2 & 3 (even Code versions) are kind of really bad in Qlik scripting. While the chinese QWEN78b showed some promising signs last week.
Do you have any experience to share on that matter ?
Any AI model to recommend ?
Are you willing to cooperate to fine tune an AI model for Qlik Scripting ?
Any suggestions on the best path to take ?
Sempre fi,
Cotiso
Hello Community,
I have a PowerShell script that uses Qlik CLI to generate the File IDs of QVDs from SaaS and store it onto a text file. This Shell script works when I run it manually on the host server but unable to execute it through Qlik Sense for Windows' External Program Task even though the result says success.
The Following is the Qlik CLI Script which works -
qlik data-file ls --connectionId 4a6e016f-b3db-4301-a934-4cdce133cdfb --limit 500| ConvertFrom-Json | Format-Table id, name > \\QLK-ANA-PUE-001\QlikSenseAppData\BatchScripts\DA-Load\File-Id.txt
The Following is the External Program Task:
Path: powershell.exe
Parameters: -NoProfile -ExecutionPolicy Bypass -Command "& {Start-Process PowerShell -ArgumentList '-NoProfile -ExecutionPolicy Bypass -File ""\\qlk-ana-pue-001\QlikSenseAppData\BatchScripts\DA-Load\Run_Generate.ps1""' -Verb RunAs}"
Please help in debugging this issue.
Thanks,
Aslam
Hello Team
We are using AWS Aurora PostgreSQL as our source and have incorporated source_lookup into the task to enhance the table structure. However, its performance is not as expected. The table on which the source lookup is configured has 600K records, and the lookup table also contains 600K records. Out target is S3.
source lookup condition: source_lookup('NO_CACHING','public','custacct','cust_acct_bs_nbr','cust_acct_id=?',$cust_acct_shipto)
It seems the processing speed is around 10K per 5mins. You can check the same on the attached screenshot.
When we tested the same configuration with an AS400 DB2 source, the performance was markedly better. IT was around 1000 rows per second.
Thank you!
Haider
I'm working on one logic.
As u can see in the above pic,
The third column shows values in orange color.
The logic is
If(DailyReportDim=[Orders Category] and $(vDailyReportValues%) < if(DailyReportDim=[Orders Category], [Threshold Start]) & '%', 'red',
If(DailyReportDim=[Orders Category] and $(vDailyReportValues%) > if(DailyReportDim=[Orders Category], [Threshold End] & '%', 'green', 'orange'
))
But it is giving only orange color . Executing only the else condition.
Can anyone check this out
And come up with a proper logic
I have a history table with the following: project name, status, create date (of status), and a bunch of other fields.
I want the most recent record for each project name & project type.
Data:
Load * inline [
project name, status, create date
Alpha, Backlog, 2/16/2024 1:41:31 PM
Alpha, Approved, 2/16/2024 1:45:13 PM
Alpha, In Progress, 2/16/2024 1:57:45 PM
Alpha, Completed, 2/19/2024 3:45:33 PM
Beta, Backlog, 2/1/2024 9:01:01 AM
Beta, In Progress, 2/1/2024 4:01:54 PM
Beta, Backlog, 2/7/2024 8:02:12 AM
Beta, Approved, 2/12/2024 12:10:17 PM
Beta, Completed, 2/12/2024 2:44:59 PM
];
My result table should show just these data points…
Alpha, In Progress, 2/16/2024 1:57:45 PM <- this was the last thing that happened on 2/16
Alpha, Completed, 2/19/2024 3:45:33 PM <- this was the only thing that happened on 2/19
Beta, In Progress, 2/1/2024 4:01:54 PM <- this was the last thing that happened on 2/1
Beta, Backlog, 2/7/2024 8:02:12 AM <- this was the only thing that happened on 2/7
Beta, Completed, 2/12/2024 2:44:59 PM <- this was the last thing that happened on 2/12
My actual data has many more columns – how would I preserve that data?
Fiz a instalação do QLIK Sense Desktop mais recente, e ao abrir, ele não aproveita a tela (Conforme print anexado).
Já ajustei a resolução e escala do vídeo, mas não deu certo.
Já passaram por isso? Caso sim, como conseguiram solucionar?
Ou melhor instalar uma versão mais antiga?
I am trying to do section access for only a specific user but all other users with access to the app I would like to grant full access. Is there a simple way of doing this without managing users in two places?
Hi,
Can any one help me why I'm not getting count(customer id) in qliksense table using 'if' condition. Please see the below data in table:
Thanks
G'day,
It is normal for the new Trial Unlock file for Qlik Sense Desktop to come out before or after it expires? Needing to refresh my memory on dashboard creation for the upcoming Qlik Connect conference in Orlando so I can get certified. Thank you!
My company has an extensive deployment of DBT to build the enterprise datawarehouse. Now we are planning to implement the Semantic Layer functionality in DBT, but we are not sure if Qlik can query that semantic layer.
Any experience in this forum?
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!