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.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
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 nine unique blogs. Check out the new Customer Success Blog!
Find a forum to ask a question or start a discussion.
Discussion Boards and Documents for Qlik Services.
Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.
Discussion board and documents related to Qlik Associative Big Data Index.
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.
I am trying to sum values based on the GL Account for multiple rows. Similar to the below:
|Name||Gross Amount||GL Account|
So basically I want to sum the Gross Amount, but only for GL Accounts '408000', '408004', '408005', and '408008'. So I don't want to include '577209'.
So my column should display a total of 17,935.
Could you help me write a function to capture the appropriate data?
In Qliksense License Monitor Application the below error occurs. Please help on this ..
Here is the underlying script
(FABS(Sum([Actual Units])-Sum([Forecasted Units]))/Sum([Actual Units]))
QV12.30SR3 - QMC displaying “Cluster is down” and the status of all tasks is “Unrunnable"
Description: We have observed that for a few minutes the QV distribution service shows as down and all the tasks in the QMC display the status as "Unrunnable".
And within some 3-4 minutes the QV distribution service resumes automatically and tasks status also changes back to previous status.
We have also observed, that there were two tasks which went into long running state since the "Unrunnable" error occurred on QMC.
we are working on Qlik View server 12 SR3
we already have a lot of source document with so many tasks defined
Now we want to change the location of the source documents; now if we change path of the source folder will the tasks still be runnable on the documents actually defined on?
Kindly advise on how to do so without losing the tasks and their triggers etc...
Somewhat new to this and could not find any similar articles.
I have a list in column A that have multiple values. I'm trying to create a bar graph where the x-axis is any unique values in column A. Y-axis is to be a total count if that unique value shows up. I've created something in excel, attached, to show what I'm trying to depict as the final graph; however, I'm unable to do it in Qlikview. Any help would be great, thanks in advance!
I'm new in this Community and i would like to submit a question about Security Access in QlikView.
Is it possibile to define an access security on a Dataset based on a specific Field? I would create a single Dashboard, but more than one user could use and interact with it.
I need that every users must see the Dashboard filtered by a specific Field for them (for example "Italy Area Manager" must see only data filterd by Field country = Italy and not other countries, but an Executive must be able to see the Dashboard without any restrictions on country).
is it possible to manage in QlikView and how can I Implement it?
I have one large data table with unique reference numbers for all events but I only want to load the data for those reference numbers that exist in three separate spreadsheets (keeping the data from each spreadsheet separate).
|Data Table||Spreadsheet A||Spreadsheet B||Spreadsheet C|
So I only want the following loaded:
Spreadsheet A = reference numbers 2 and 4 (loaded as Ref A)
Spreadsheet B = reference numbers 3 and 7 (loaded as Ref B)
Spreadsheet C = reference numbers 1, 2, 4, 6 and 8 (loaded as Ref C)
Hoping this makes sense to someone!
QlikView 12.30SR3 - Extra decimal places while exporting data in excel
Description - When trying to do an excel download for a straight table having the 'Number Format Settings' as "Expressions Default" the values are showing up with 14 decimal places in the excel.
We have also tried changing the format to "Fixed to" 5 decimal places and it gave number with only 1 decimal place.
Whilst in 12.10 the decimal places for such straight table setting was 4.
Is there any manual setting where we can change the decimal places to 4 for a straight table?
is it possible to change the sort order in the export list of the on demand control? HTML is currently standard. Xlsx should appear as the first value.
Thanks for your help.
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.
Get the most value from your data and see the hottest trends in data and analytics. Join us in Phoenix, AZ. Register by December 31 to save $400.
An exclusive online event where industry experts share practical advice to help your entire team take charge of their data.