Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.
Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.
This forum will provide you with event highlights and related content to get you energized and ready for Qlik’s largest customer and partner event of the year.
Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.
Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.
Discussion Boards and Documents for Qlik Services.
Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.
Hear directly from Qlik employees in our nine unique blogs. Check out the new Customer Success Blog!
Learn about upcoming Qlik related events, webinars and local meetups.
Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.
Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
I have to create a line chart of my count of ID's by weekstart.
Now my requirement is like :
I need to show all the tickets which were opened in past till current weekstart date for example :
If you look in the above table I have ID-1 for Low on date 22nd-Nov-2019
when i covert the date to weekstart (I have Master Calendar) then the Dimension would be Weekstart and expression is count(ID) by doing this when the line chart shows only the dot for Feb-09-2019 .
What i want is to show is that , the count of (ID)which is one (on Feb-09-2019 ) should keep showing 1 count till current weekstart which is 17th Feb-2020. ( if theer is no data for any of the weekstart then the line chart should show the previous data .
How do i achive this ? can someone please hep me on this
thanks in dvance
I am running into a problem with my expression.
This is ultimately what I want: I am trying to subtract any paused time from the total time and then get an average for the dimension type.
Avg(Interval(rejejctedtimestamp - submittedtimestamp,'hh')) - Sum(PausedTime))
It will not allow me to nest the functions. I can remove the Sum from PausedTime and I don't get the error. But it doesn't work correctly.
Not sure what my options are here?
In Excel we have function called YEARFRAC , is there a same function in Qlik.
|Start Date||Maturity date||YearFrac|
Suddenly we are receiving error messages in Task Execution log:
I have checked the logs and below message is there for multiple users
ERROR QLKNPRNT 0 0 0 0 0 0 0 0 Failed to send e-mail message to firstname.lastname@example.org. ERROR: System.Net.Sockets.SocketException (0x80004005): No such host is known↓↓ at System.Net.Dns.GetAddrInfo(String name)↓↓
It has started from last week and occurs randomly.
Can anyone help us to fix it ?
I am facing a number of problems, now with the impending discontinuity of Qlik Sense Desktop.
I created the qlikcloud environment for the company, however when creating it, I created it with my email. Now, I would like to change the tenant, or the manager, or whatever the name is given to the general owner of the environment. And I just can't find this option anywhere. Even changing the user settings by editing their functions at https://empresa.us.qlikcloud.com/console/users/ in the "users" tab, placing another user as "tenant admin", disabling ALL other users including mine who is the current manager, even so, i can't change. Because only my e-mail can verify the licenses and buy licenses.
Gentlemen, in short, has anyone gone through this, and already had to change the master user or key of the cloud, who can pass this information to me? Important detail: I was in the trial period, which is now closed. I clicked on prolonging the test, and nothing happened. And I don't want to buy the license with my user, precisely because I don't want him to be the general manager of the cloud, and because I don't want to burn a license with a user who won't have access. That is why my need to first change the user and then hire the service by purchasing licenses.
Dresner Advisory Services is inviting all business intelligence (BI) and enterprise performance management users to participate in its annual examination of the state of the BI and analytics marketplace focusing on drivers, usage, and products.
The 2020 survey covers overall BI deployment trends and related technologies and initiatives including cloud computing and BI; self-service business intelligence; data catalog; marketing analytics; data science + machine learning; and the role of the BI Competency Center (BICC). The survey also covers Enterprise Performance Management usage and intentions, including strategic, operational, and planning initiatives, as well as sales performance management.
Users in all roles and throughout all industries are invited to contribute their insight via an online survey. The 2020 Dresner Advisory Services research will be published beginning in late Spring and throughout 3Q20. Qualified survey participants will receive a complimentary copy of the findings.
Click here to start the survey today! The deadline is March 31st.
I am trying to create a map using GeoAnalytics.
I would like to use UK postcode data to map sales based on a drill down of Area, District, Sector, Postcode.
Country = UK
Area = PO
District = PO14
Sector PO14 4
Postcode = PO14 4LW
Does anyone know of any documentation to help me set this up, every video I find doesn't show any UK examples.
I have multiple CSV files with slightly different columns that I wish to concatenate load into a single table. Each file contains approximately 120 columns.
Unfortunately, the source files also contain multiple "Filler" columns (header = "Filler").
So, this fails:
Load * Inline [
// This method won't work, because the file is littered with "Filler" columns (field names must be unique)
For Each File in Filelist('$(vPath)/$(vFileMask)')
SET vFile = '$(File)';
(txt, codepage is 28591, embedded labels, delimiter is ',');
Is there a way to dynamically load multiple files, but exclude (or dynamically rename) columns named "Filler"?
Please help me on achieving this logic
I want to show Product & Last updated Price in Straight table based on date selection in listbox.
I have tried with Firstsortedvalue,by default it is showing Lastupdatedprice Product wise But i want to show LastupdatedPrice for Selecteddate.
I have generated missing dates with master calender and tried to populate missing Product & Price using Peek function But its nor working..
I hope someone can help me since this is driving me crazy.
I have a simple table with all the fields of the model which are 9. After some date filters, only one row show up in the table but my kpi shows '2' as value.
My script is:
I would appreciate some help please!
Thank you in advance
Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.
This group hosts information related to the Qlik Deployment Framework (QDF).
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by February 29th to save $200.
Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.