Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
A live, in-person thrill-ride - full of insights, learning, and peer-to-peer connections.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Hello
i have a task setup from source (Microsoft SQL server) to target (Microsoft SQL server). there are three tables of which two are transactional data and i have noticed that for one of the tables, updates are not captured. Inserts and deletes are the only change processing that the LSS captures for one of the tables. This has led to discrepancies when queries are run and comparedon both the source DB and the target DB as the updates made on the source DB are not captured on the LSS task.
A column in the table on the source DB may have 0 as the value but later it gets updated to a 1, this action/change doesnt get effected on the target DB so that particular records remains 0 on the target DB.
Has any encountered this challenge before
I'm trying to create an expression that says - if the field [Projected Close Date] is 370 days or more in the future, sum the combined_amount. Here is what I've written, but it isn't correct. What am I doing wrong?
Sum({<Date#([Projected Close Date])>={Date#(Today())+370}>}Combined_Amount)
Hello to all
I have a list of cusomer with quantity, date, region, sub region and Sales responsible. I woul like to do a pivot table with region, sub region and Sales reps in row and column of month. The data to be displayed are the sum of quantities realized in 2023 for the customer that did not had any sales during the last to years (Q= 0)
i have tried the follong formula bu it does not work at all
=if(aggr(sum({< YEAR= {"<=$(Vannee-1)"},NO_CUST=,MONTH=>}Q),NO_CUST<=0,
sum({< YEAR= {"$(Vannee)"}, NO_CUST=, MONTH=>}
Q),0)
I have added in excel cause it shows in the pivot what i want.
Thanks in advance....
Hello,
I have default data that looks like below, where for each order id i can have multiple values in field (Initial Status):
OrderID | Initial Status | New Status | Orders |
Order 1 | Approved | Approved | 1 |
Canceled | Approved | 0 | |
Declined | Approved | 0 | |
WIP | Approved | 0 | |
Order 2 | WIP | WIP | 1 |
Canceled | WIP | 0 | |
Declined | WIP | 0 | |
Order 3 | Declined | Declined | 1 |
Canceled | Declined | 0 | |
Order 4 | Canceled | Canceled | 1 |
I want to count unique orders depending on values inside status field : if status = approved, count it only once, no matter what other status this order has or return a new status as 'approved'; The 4 orders from above are 4 situations possible.
Thank you in advance for your help!
Hi Team,
I am facing issues while loading full loading file with Qlik Replicate. I have explained the issue in given steps below:
Full File load every time >> Frequency will be for every one hour >> Need to process latest files for every one hour
In my requirement, we used to receive the files from vendor with full set of files for every one hour, in that case they used to keep on appending the files in same location for every one hour, so Qlik replicate either to identify the latest files & to process them, or i do need to archiving the files manually after processing through Qlik Replicate every one hour which is again tricky since we don't predict when files arrives at source.
I am facing issue in identifying the options for full load with given options in Qlik Replicate, hoping can someone from Qlik support could help me on this.
Thanks in advance!!!
Hello, we have some tasks that read delimited text files as sources and put them into MS SQL target.
Is there a way to move the files to a different location(Folder) after they have been processed successfully?
E.g. The files are dropped in F:\Share\Source and then after processing must be moved to F:\Share\Processed
I have tried to set the values that I found on the Endpoint Connection itself, Under Change Processing Cleanup, but this doesn't seem to want to work for me. Nothing happens.
We are using: Qlik Replicate May 2021 (2021.5.0.1272), running on Windows Server 2019 in Azure
I have an application in the name like as "application 1"
but when i search like " " the application "application 1" is not picked up.
why just space is allowing to pickup the application that has a space.
even in the root admin column of qmc application, I am unable to sort by blank values? is there a way to accomplish this .
Qlik Compose for Data Warehouses
I want to map a column using a lookup to a view column located in the DW (not in the source). The GUI does allow the Data Warehouse to be selected as a source for the lookup. Please advise.
Hi Everyone,
Please help me to find the formula script based on previous row.
Now I want to calculate the stock for all the months and the formula is :
((currentMonthProduction * Previous month stock) + (current month Sell )) / (Previous month production - current month production)
Let me give an example of how the data is
Please help me to write this script?
Thank you
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
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.
Get ready for QlikWorld: The Conference for Data Thrill-Seekers. From exciting innovations to spine-tingling keynote presentations and lots of peer networking, you'll discover how you and your data can help your business succeed.
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!