Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
Submit questions to product experts and participate in conversations.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Hi all,
In a straight table, for a specific column - Company
I have to insert "No value" if the value is null.
I have tried 2 things, both didnt work:
1) IF(IsNull([Company Name]),'No value',[Company Name] )
2) if(len([Company Name])<1,'No value',[Company Name])
Feels like it worked for me in the past, no ideas whats wrong.
In both cases the expression was valid but the column still shows "-"
Thanks
Hi,
I am new to Qlik sense and I am trying to show some data on map chart. What kind of data I need to have in order to to show some hospitals and number of patients in these hosptials? Thanks in advance.
Hello,
We have an application developed that contain a big data model with around 5 millions records in the different tables combined.
The application contains some complex measure and aggregations requested by requirements design.
The sheets load fine when we have two widgets containing like a dozen of dimensions and a dozen of measures.
However some end users insists on displaying all KPIs/Measures and all data in one single sheet. For example in one sheets we have:
The sheets becomes barely usable especially when no filter applied
What is the standard recommendation for qliksense for a single sheet? how many widgets/dimensions/measure should we have a single sheet to not abuse the flexibility of self service?
Thanks
Elie
Hi everyone! I'm building dashboards for HR Statistics in Qlik Sense. I've made some basic courses in qlik platform and took one Udemy course; however, there are some concepts are not clear enough and also I cannot find relevant information about how to do/build some formulas or calculations because mostly I just find sales examples which in my case are not very helpful.
Right now I'm struggling with 2 main issues:
I need to count how many employees where active in each month, each employee can have several hiring dates and attrition dates but I also have a fixed number of employees that need to be added to previous count.
Holidays Dashboards: I need to build in the same app the availables holidays for each employee according to their country and it's legislation ( USA, Panama, Netherlands and Spain).
I'm looking for someone who can guide me a bit better in master calendar, Set analysis and scripting in order to finish the dashboards I'm working at. If someone is interested in gaining some extra cash and help a lost soul in Qlik's world I'll be more than happy if you PM me.
Thanks in advance and cheers.
hey ,
i am trying to load Data To all my app in qlikSense Desktop,
i wrote the script that loops through all the apps using GetDocList function, and i pass the app name a function That Load The Data via QlikSense JS API (every iteration) but i need to "Wait" for every doc\Doc to be loaded\Updated before the next iteration. can you help me???
another thing i noticed is that if i have an loadData Error it continues without displaying the error, hoe can i deal with "Load Data" Errors?
My data has dates very very wrong extending to 8201 Year and now I can either remove all the data where Year is more +- current year, but I am thinking of making all the dates which are above a certain date like today+5year to be maximum of 31-12-2099 something like that in floor value, due to date being so out of range Date Picker isn't working and fields tags take it as numeric instead of date I have used floor everywhere for my date values.
P.S. I have already tried advance settings they don't work either, while selecting dates in date picker it says no data available and dates are grey not black like normal.
Hey guys,
So I have a table that lists multiple product orders for multiple stores. The fields in the table include all kinds of information regarding the seller type, buyer type, product type, etc... However there is absolutely no unique IDs in this table.
This is an issue since I am trying to make a unique identifier for each overall store transaction (not for each individual product bought). I don't want to touch the data load editor.
Is there a way for me to create a master item dimension that serves as a unique key for each transaction. I want to create a master item that combines multiple dimensions in order to create a unique identifier. How do I write this expression?
Hello,
I have this 2 incomplete datasets and I would like to assign ids to the first dataset from the second one using hte email field.
Does Qlik provide any ability to perform fuzzy matching? I have millins of records to update and hope to use a Qlik to update some of the records.
name | address |
ck,mar | chicago |
asos asos | paris |
p c | paris |
id | |
2345 | manager@charleskmar.com |
6753 | asosciate@chicagoassociate.com |
2831 | pascal.c@pascalcarlos.com |
My Expectation:
name | address | id | |
ck,mar | chicago | 2345 | manager@charleskmar.com |
asos asos | paris | 6753 | asosciate@chicagoassociate.com |
p c | paris | 2831 | pascal.c@pascalcarlos.com |
Any ideas is welcomed.
Hi all
I need to add to my report the number of rows that exist in it at any given time.
I was asked to place this counter on top of the report as a kpi (near the date time)
any Ideas?
thanks
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!