Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm using QRS API to create users in Qlik Sense on-prem version via code.
Now I have a new requirement to update user id, It means I need to find existing user in Qlik and update his userid.
Is it possible to do it using QRS API? I found this reference but I think it's only relevant for Qlik Cloud:
https://qlik.dev/apis/rest/users/#%23%2Fentries%2Fv1%2Fusers%2F-userId-patch
Thanks,
Eli
I want to trigger a Qlik Cloud App reload when an external process is finished. This process can execute a PowerShell script. Is there a method in which I can trigger an App reload using a Powershell script? How can I connect to the App reload using an API Key?
Hi Everyone
I would like to check if there is any endpoint available to disable a user. I checked the documentation but couldn't find anything related.
Regards
Sivanesan
Hi All,
I am trying to make a text used in set expression as bold. I dont know how to do it.
Need help on this please.
'Sales Actual Retail: '&num(Sum([Sales Amount])
I want to make 'Sales Actual Retail: ' as BOLD.
I want to show chart and insight in WhatsApp using chatbot from the qliksense dashboard , is there any way either easy or difficult. Please let me know I am in dire need of this possibility.
Hello,
I have this load script for one of my app in Qliksense.
Table1:
Load
First_Name,
Last_Name,
Salary,
Fiscal_Year
SQL Select
FirstName as First_Name,
LastName as Last_Name,
Salary,
FY as Fiscal_Year
From XYZ_Table
In the sheet, I have this simple table with Fiscal_Year column that shows all the data for all the years.
User requested to filter the data to only shows the current year and two previous years. I have adjusted my code to this:
Table1:
Load
First_Name,
Last_Name,
Salary,
Fiscal_Year
SQL Select
FirstName as First_Name,
LasrName as Last_Name,
Salary,
FY as Fiscal_Year
From XYZ_Table
WHERE Fiscal_Year >= (YEAR(GETDATE())-2); //to get only year 2024 and 2023,2022//
It loaded successfully and I got no errors, but when I go to my table in the sheet, I still see years from 2016-2021
I am not sure what I am missing. Could someone please help me with this?
thank you!
Source is SQL MS-CDC, we created full load + CDC task and perform DDL operation(add column) and Qlik replicate is captured that one.
Same operation we created when task in stopped state. Then we resumed the task, then table got suspended.
We tried to reload the table and task, while inserting a data in source and table got suspended. In that scenario, how should we run the task?
When I create a credential for Sharepoint (in either Personal , Shared or Data spaces), I am able to retrieve files successfully. However we were not able to share this data connection with anyone (even admins).
In other words, if another user tries to use the data connection in a load script, we get the following error message:
Cannot open file 'lib:xxxx' (Connector error: No refresh_token found for Office 365 Sharepoint).
Our expectation is that the token would be saved for the connection not having to generate a token for every single user. Also if it's not the case, how can we schedule a reload if the data connection can only work for a single user?
Hi,
I have previously successfully used If statements for the colour of bars in bar chart based on the sales year.
However, when I set the background colour to RGB (49,130,189) it works as expected but the If statement IF(SSDate_CY ='2023',RGB (49,130,189)) does not.
Anyone got any ideas why it is not working as expected as the statement was copied from a chart in another QV app that worked 100%
Thanks in advance!
Hi,
We have around 10 tasks which are triggered at the same time. I notice that after few tasks completed successfully, one of the task stuck at 50%progress(in Running status) even after generating the excel reports in output folder. So this and rest of the tasks stays in the queue for hours until i restart the 'Qlik NPrinting Engine'.
Any suggestions, please
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!