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 have a line chart which shows the trend of sales by week . I used the data refreshed date as date field , it was every monday .
So , my requirment is I have to show the Average trends by month using the Date . How to show the avg percentage by month ? Pls let me know if you required details.
For example june month Avg will be = 96.60+96.64+96.69+96.78+97.06/5
I have pivot table like below. I want to color background min and max number by month(Ay) or like picture right.
I used formula like this. =colormix1(sum(Sales)/Max(TOTAL aggr( Sum(Sales),Month,CategoryName)),yellow(),lightred())
But my pivot tables formula very long as below. so could you plase help me.
my pivot table formula:
if([Net/Brut]='NET', sum(if(month(Veri_Kesit_Tarihi) = Month(Today()) and ([Ürün Durumu]='paymentrequired' or [Ürün Durumu]='continue')
sum(if(month(Veri_Kesit_Tarihi) = Month([Proje Gerçekleşme Tarihi]) and ([Ürün Durumu]='paymentrequired' or [Ürün Durumu]='continue')
My Pivot Table:
Customer is requesting if it's possible to have the the bar chart default to the most recent date so they don't have to scroll to the right everytime they open the Qlikview app. By default, the Bar chart displays on the first date data is available (see screenshot #1), what we'd like it to default to the current date (screenshot #2). Any assistance would be greatly appreciated.
Hi dears, hope everyone be safe in your houses 🙂
I am finishing an App in prototype and going to industrialization and that's why I am including SESSION ACCESS with Reduction (this last one is working fine )
Issue: Some users cannot access the App (error: Access Denied), but other users can. Obviously I have checked like 3 times to make sure the users are into the table of users
How am I loading the Users?: As we have some different countries and each one share/access data, we got different folders in the network and the idea is that any country could see only the information of its on country. That's why I created a file inside this folder where I expect the local "app owners" can include the users they want to have access. When someone needs global access, I am the responsible for giving access and I include the user in the appropriate table where only I have access.
Attached the script and also the files I am using. Could someone give me some direction of where should I start looking for?
Has anyone ever come across this? I have a straight table that contains 50 rows and when I use NPrinting On-Demand to generate an Excel report using this same table, I only get 35 rows in the report. However, if I export the table from Qlik Sense directly to Excel, I get all 50 rows.
My company is currently on the April 2020 Release.
Appreciate, if I'm helped with, to calculate average at the script level so that I need to be able to write a nested if statement to prepare a class like (>30000, 20000-30000,10000-20000 ) etc ,based on the average computed at the script level. Since the value given is not the average the class function to be based on the average. Also, the average here should be the half of the value of each employee.
Thanks in advance
I have EID,Date(multiple months) and TeamCode.
If i want to check if TeamCode or that EID for that month is same as previous or mentioned month , how do i do it in set anlaysis.
I want count of those EID, whose teamcode for that month is not same as previous/variable month.
About a month ago, our virtual server that houses Qlik encountered a low drive situation where it hit less that 10% available. While I figured 25GB was still plenty, Qlik didn't like it, and it crashed on me. We recovered the entire virtual machine from a backup, I cleared out TONS of old logs, and freed up over 80GB of space. Ever since this event, several of my monitoring apps won't reload. Most of their error logs are showing a version of this:
20200715T164146.440-0700 0557 SELECT * FROM "public"."view_audit_activity_audit_security"
20200715T164146.440-0700 0558 WHERE entry_timestamp >= '2020-04-15 00:00:00'
20200715T164147.171-0700 Error: Field 'entry_timestamp' not found
I figured since we were running on the November 2019 release, and I needed to perform an upgrade, things would resolve themselves when I went to February 2020. I've done that this past Monday, and it's still having issues.
So here's my question: I believe there are QVDs or other supporting data on the Qlik server that I can remove & the apps will rebuild the data sources that they need. Based on that, can someone point me to links or information on what to remove? I've done multiple searches, but feel like I can't find specifically what is necessary.
Thank you in advance, and I appreciate your efforts to guide me!
Apps Currently Failing:
|2020-05-31||1111||012C||South||Retail A||Digital A|
|2020-05-31||2222||132V||North||Retail B||Digital B|
|2020-06-30||2222||472H||East||Retail C||Digital C|
|2020-06-30||3333||475U||East||Retail C||Digital F|
|2020-06-30||4444||413N||West||Retail D||Digital G|
|2020-07-31||2222||763I||East||Retail D||Digital H|
|2020-07-31||5555||472H||East||Retail C||Digital C|
|2020-07-30||4444||472H||East||Retail C||Digital C|
This is the employee data, i want create headcount analysis.
I cannot do anything in the script. All data will just get appended anymonth.
User will select 2 months for comparison and
They want get New to the company, Retained , Resigned from the company, Internal transfer
this should be valid based on selection of Region, Department and Team
So when i compare June and July Month i select only Team (Digital C ), I should get output
New to Bank: 1 (Employee 5555)
Resigned from Bank: 0
Internal Transfer: + 1 (Employee 4444)
Internal Transfer: -1(Employee 2222)
So when i compare June and July Month i select only Region (East) , I should get output
New to Bank: 1 (Employee 5555)
Resigned from Bank: 1 (Employee 3333)
Internal Transfer: +1 ( Employee 4444 )
Internal Transfer: -0
Note: Any two months can be selected for comparison, Jan Mar, Jan Nov, Feb Apr, June Nov, etc
Hint: Lowest grain is Team Code, If team code of employee is present and not present in last month , he is new to the bank,
if team code of employee is not present this month but present in last month, his has resigned
if team code is present for both month but different and it is same as filter selection, +ve internal transfer,
if team code is present for both month but different and it is not same as filter selection, -ve internal transfer
I have a composite key of EmployeeID,Teamcode at the backend if useful
we want to create column based on measures, for sample as below, could you help to share some ideas? Thanks in advance.
For below screenshot what we can achive in Qliksense now, we want to create column, for column C(Budget) and D(Consumption) we create column'A' for them, for E(Scan),F(Second_scan) and G(Retailer_Scan), we create column 'B', for H(Budget%),I(Second_Scan%) and J(Retailer%) we create column 'C'.
Below screenshow was what we want to achive,
Is it possible for this setting in visualization level? Thanks.
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.