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.
Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!
Participate in Qlik Technical Previews, submit ideas, and review documentation.
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.
Learn about upcoming Qlik related events, webinars and local meetups.
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 ten unique blogs. Check out the new Product Insight & Ideas Blog!
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Learn how by attending the webinar “Modernize Your QlikView Deployment” on November 3, 2020 at 12:30 PM ET.
Join us on November 11th for the final Qlik Insider webinar of 2020.
We will provide details on AI enhancements and the new Insight Advisor, expanded enterprise data cataloging capabilities within Qlik Sense and beyond. Extended API support to open new embedded analytics opportunities, new and improved visualization to showcase your data in the best way possible, and much more. Don't miss your final chance to bring your product release questions to our experts!
Is there any way to pass field value in QlikSense App url having special characters.
Below URL is working
Below URL is not working
Please suggest how we can pass special characters in URL
I have a dataset like this-
Now, I want to create a straight table in Qlik Sense that will have Race, CinemaStratum, CinemaPSU as dimensions and sum(UtilityWt) as measure. I want the straight table to look like this-
But I want all the CinemaStratum and CinemaPSU to be included for each of the races. Even if some of the cinemaStratum/cinemaPSU does not have utilityWt, I want 0 to be inserted in that row for the measure i.e. I want to have 10 rows(total no. of PSUs) for each of the races. All I have is the table below which does not include the missing stratums/PSUs.
I am at my wits' end about how to proceed further. I have created an island table but with my little experience of data modeling I can't really connect it to the fact table and compare to include all the values. I don't even know if that's a feasible solution. I would appreciate any help or suggestions.I am really looking forward to hearing from all the experts here! I am attaching my dataset and application(please refer to sheet2) here for reference.
I have a problem that has been haunting me for several days. I have a table with this data:
| date | quantity |
Quantity is the daily stock of the warehouse.
I have a table as a master calendar which shows the date, week, year, etc.
My goal is to calculate the weekly variation ... how can I do?
I attached the tables..
part of master calendar
I have a calculated x-axis that ranges from -19.20 to 800.72. Usually in Qlik View we can use Axes --> scale --> Static Min; Static Max boxes to set ranges for x-axis. But dont know how to do it in Qlik sense?
Infact I dont even have Range option showing up for my X-axis. Only for Y-axis I have my Range option.
My calculated dimension is "=num(Minute/60 , '##.##' )"
Any help will be much appreciated. Thank you.
Hi, I know there are a number of threads that have been raised regarding aggregation in QV scripting and have looked through a lot of them to try and solve my issue.
I have a fairly decent size data set stored in a QVD (7.5 million rows).
I have written a load script to extract some of this data and aggregate it together.
My source fields are PositionId, ForecastDate, ForecastHours
on my initial load into a temp table I have -
week(ForecastDate) as FWeek,
I then have a final table -
sum(ForecastHours) as Fhours
Group by PositionId, FWeek;
Drop table temp;
This should be as simple as can be, if I use a simple inline table as my source (with about 15 rows) I get the correct data out. However when I use my real data source my FWeek AND ForecastHours are both showing incorrect.
Hopefully someone has an idea of what I am doing wrong and how I can fix it.
I have column "Mx" with minutes as numbers and have column "sold (yes/no)" with number of items sold. When an item is sold, "sold (yes/no)" column will have "1" otherwise "0".
I want to create a bar chart with hours in x-axis and number of Total items sold at a given hour in y-axis.
At the moment I got
dimension as hours "=interval(Mx/60,'h')" and
Measure as "Count(sold (yes/no))"
Above expression results in repetition of x-axis values (please see the attached image). How do I consolidate x-axis and display total count of sales every hour?
Hi, I'm trying to remove borders on Navigation Button.
The button have a borders because I've inserted a css code like this
I've inserted that code because I have a requirements regarding how the chart should look. But I also have a requirements that the buttons should not adapt the border and border color of a chart.
I have searched and have not find one of any documentation or examples of configuring the css style of a navigation button.
I hope it is configurable!
We started using the .net SDK in combination with the Qlik-Cli for Windows version for deploying apps to multiple streams.
For every stream we would like to change some variables in the Data load editor. Is that possible with the SDK? I found some options for changing the script with the engine JSON api but not with the SDK.
We have these 3 variables that we use to connect databases, we would like to change for every stream:
let CustomerName = 'CustomerA'
let DWH_CustomerName = 'DWH_CustomerA'
let Source_CustomerName = 'Source_CustomerA'
Would it be possible to search and replace these variable values in the load script?
On Qlik Sense I have a map with an area layer, is it possible to hide the label "area layer" (= "couche de zone" in the screenshot). I want only the legend
Meet Kush our featured member for October 2020
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.
Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.
We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.
Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
The new normal requires a new approach to data. Join this event to learn about the latest trends and approaches for accelerating value from your data.
Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’
Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.