Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Participate in Qlik Technical Previews, submit ideas, and review documentation.
Learn about upcoming Qlik related events, webinars and local meetups.
Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Hear directly from Qlik employees in our ten unique blogs.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Access Support programs, Knowledge Base, Updates blog, and Release Notes.
Here you will find a list of all the Qlik Community forums.
How did Gordon Food Service, Breuninger and other customers move enterprise-wide data to the cloud – and increase their time to value? By automating data integration.
In this on-demand webinar, you’ll hear from Google and Qlik, discussing how a data integration platform enables real-time data analytics pipelines to the cloud – unlocking massive amounts of fresh data and ensuring its continuous availability enterprise-wide.
I have a set analysis formula counting Sales from “Germany” as follows:
I would like to however only consider the uniques of a third column called “Submissions”. The current selection double counts Submissions.
How might I go about removing all duplicates of a third column / submissions column?
I have 3 tables Customers, Accounts and Transactions. What is the best way to create a link table between them as I'm not to sure how to go about this with the load script. Hopefully this makes sense. Sample in excel was created
The specific links:
-SourcePartyType = 'C' & SourcePartyID = CustID
-DestPartyType = 'C' & DestPartyID = CustID
Sometimes a transaction can be made by a combination of the 2. Eg customer made a deposit to an acct
Any guidance would be great thanks
I need your help with the data set (as an example I put it in excel):
What I need is to fetch during of calculation for field "Purge" the fileds above calculated (for example cell D10).
Is there function in Qlik Sense which let me to do it?
I know that above() works only in table/chart, but is there an option to do it in my script?
It's a straightforward AngularJS extension, and I've found the article for retrieving extra data here: https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/Extensions/Content/Sense_Extensions/Howtos/get-additional-data.htm
Basically, at the end of the day, I'm trying to work out the best method to loop through all pages of the huge HyperCube in a single execution of paint so that I can modify the structure of the data to suit the needs of the extension.
I've added comments to the code here to better explain what I'm trying to achieve.
Imagine you have a data island table with two columns, e.g. "Metric" and "Function". The function column contains a syntactically correct formula per metric which calculates its result over the remaining tables of the data model. Then create a table object in the UI and have Metric as dimension and the expression "$(=[Function])" as measure column. The output is an empty measure column unless I select one of the metrics in the dimension columns, then Qlik Sense Enterprise SaaS shows the correct result for the chosen metric. How do I need to formulate the expression so that it calculates the results for all rows right away? An empty sample QVF using the data model generated by hitting CTRL-0-0 in the load editor is attached
Hello Qlik Community,
Using set analysis to try and see whether Population or CO2 Per capita is the real trigger for our current excessive level of CO2 output via a "What If" using Set analysis, possible values P() and AGGR and Linest_M in the script.
Attached video explaining the app and logic and also the QVW application.
What are your thoughts?
I have below field where the data is commencing from 2010 till now.
My requirement is i have to show the data only for current year in this filter pane i.e it should show the dates starting from jan 2021 till the maximum. I don't know how to restrict this in filter pane.
Can anyone please help ?
Thanks in advance
Where should I make a calendar table in ETL?
Following different examples I have observed people are creating it in Transformation Layer, but why , why not in Loading ?
Use of Link Table:
Making LinkTable following two stages, first loading fields from Table 1 and concatenating with Table 2 and then making keys out of it and this Link Table is created in Loading , after some research I have come to know it saves RAM, if it is made in Transformation Extra Storage space would be consumed as it is loaded again in LinkTable.
Someone with sufficient knowledge on these topics according to best practices, please throw some light.
Our featured member for September 2021
Learn about what's new across all of the products in our growing Qlik product portfolio.
Hear from the Qlik Community team about the latest platform enhancements and other topics.
Important and useful support information about end-of-product support, new service releases, and general support topics.
German speaking - This group makes it easier to collaborate in your local language.
This group for Brazil users. All discussions are in Portuguese.
This is a open Group for the Public Sector
These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.
You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.
Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.