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.
May Qlik Alert You – 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!
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.
Participate in Qlik Technical Previews, submit ideas, and review documentation.
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!
Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.
Discussion Boards and Documents for Qlik Services.
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 am a beginner in Qlik Sense. Since I am working on a huge dataset, I am aggregating the values before importing it in Qlik Sense to improve the performance. Now, I wish to only display a pre-aggregated field in a KPI chart. Below are the options that I get while adding a new measure to the KPI chart.
If I forcefully edit the expression to remove the aggregation, it does not display any value.
My aggregated table now looks like this:
So I plan to have a Filter panes for Year and Gender and KPI chart or Patient Count.
Can anybody kindly suggest a work around?
Any help will be greatly appreciated! Thanks!
In a combined chart: how to add a second measure to "height of bar". I am currently only able to add a second measure to "height of line" See attachment
how to use this kind of function in QlikView
IF(06/30/2020 > FieldDate, "yes" the also
IF field A- (MONTHS BETWEEN 06/30/2020 - FieldDate) == REM, "CURRENT"
I have to create a pivot table like below. I have 8 expressions and 3 dimensions. A sample requirement is below.
I have created the NSC and TSC part , but I have to create a summary part as well.
So in the summary for Programme A the YTD should TSC-A + NSC-A(100+200=300),
similarly for B it should be TSC-B + NSC-B.(500 + 100=600).
Is this possible ? Please can any one help?
I am trying to implement Section Access on some fields.
LOCAL table is sort of a super set table of DIVISION table with two additional values
Here are my requirements:
1. I need to grant ADMINS access to all the values in 3 fields.
2. All USERS should have access to MEDICAL and PUBLICITY in LOCAL by default
3. I need some USERS to have access to SALES and CORPORATE in DIVISION
4. I need some USERS to have access to SALES in DIVISION, ACCOUNTS in BRANCH
My Credentials are based on IDs. I tried some methods but 2nd condition keeps failing if I enable other conditions. How do I achieve this?
LOAD * INLINE
I have tables as shown (First row is table name)
I need to check if ID2 has any matching values in Full Table 'ID' and if it does, then check if ID2 matches with any Limited table 'ID'
In simple case,
if(Alternate Table ID2 = Full Table ID, then check
if(Alternate Table ID2= Limited 'ID', then 'Yes','No') in the script.
How do I achieve this in the script?
Today I read that QlikSense desktop will no longer available for download and use (as well as existing installations) from June 2020.
Rumour or fact ?
Why do this ? Besides profiteering ? Surely there are other ways to encourage early adopters ? Forcing people to Qlik SaaS offering is not a great option as it does not support much in the way of extensions and of course locks out 3rd party extension provides such as VizLib which I use when prototyping before migrating to a server.
I'm trying to create a macro user-defined function like this thread:
Function addTheseForMe(var1, var2)
However, when I try to run this in script:
LET varA = 7;
LET varB = 8;
LET varAB = addTheseForMe(varA, varB);
I get this error:
Unexpected token: '(', expected one of: ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', ...
LET varAB = addTheseForMe>>>>>>(<<<<<<varA, varB)
What is wrong?
While it's hard to believe we are in August already, it does mean a new month and another opportunity for our monthly "Round of Applause". This month goes to our very own Qlik employee Brett Bleess! Brett is part of our Digital Support team, has over 3500 posts, and countless interactions in the community. Brett is a valued partner to our team and we appreciate all of his interactions and moderation he provides.
Brett started with Qlik in Oct 2004 and has been a part of the support organization the entire time due to his overwhelming drive to solve problems. When he started, we were on version 6 of the QlikView product and that was the only product we had! His community presence is part of his job, however, he really enjoys spending time in the community as things tend to be a bit more laid back and collaborative than in the case environment. Also, much of the time things are not as urgent and people tend to be much more appreciative of the help/guidance they receive. While he mainly collaborates in the QlikView product area, when time allows, he is able to get into the Qlik Sense forum.
In his spare time, Brett enjoys doing projects around his house as well as for friends and family. He has a dedicated woodworking shop in his backyard with a full suite of tools. He really enjoys building new things and fixing old. Brett grew up on a farm and really misses working on tractors. He wants to buy a subcompact tractor, so he can do projects using the tractor. Due to the virus tractors are in short supply, however, he is hopeful to buy one soon.
Meet Marcus our featured member for July 2020
Hear from the Qlik Community team about the latest platform enhancements for April and May 2020.
Read all about Qlik's Voice of the Customer program and Customer Success initiatives.
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.
Amazon Produce Network and Odyssey Logistics discuss how they’re using Qlik to help manage their operations during Covid 19
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.