Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.
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.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
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.
My Qlik Sense charts don' show Full Screen option when hovered over. I read articles on how disabling touch screen solves this issue. But it does nothing to me. Any other lead would be really helpful. I created a new chart, tried both extension and native qlik charts and still no change in the behavior.
We are working on a multitenant solution and are leaning towards moving transactional db's to exadata. Currently we are on Oracle DBaaS and use Replicate to move data to Snowflake
Hi Experts,
I have the Transaction Amount as ₹72,234,435,457 . Here I want to format it as ₹72,23,44,35,457. I tried using the formatting as ₹#,#0,##0 but it is not working as expected. Could you please help here.
Thanks in advance!
I have an issue whereby an occasional UTF8 character is in a text field and this causes the whole Qlik reload to fail (bringing the data via ODBC). Is there any way to enable Qlikview to be able to handle these characters?
I've been trying to figure out this formula and I'm stuck.
I'm pulling data in where i have a starttime and endtime which is in UTC minutes. I need to covert that to different timezones based on each record. Sample data below.
I need to display start and end time in hh:mm TT format. Here is where I think I've gotten the closest one to work. But for some reason, it's not displaying the correct AM/PM time?
Need help identifying what I'm doing wrong. Below is what i have in START_TIME3, which seems to be cluse, but just not exactly right.
Date(ConvertToLocalTime(Time(startMinuteOfDay/(60*24), 'hh:mm TT'),'Central Time (US & Canada)',FALSE()),'hh:mm TT')
Hi! I have an input box where a list of values can be entered, comma separated, and they are assigned to a variable. I have a button with an action to select values in a field based off that variable, and the values are =Aggr(Only({<equipment_type={$(vEquipType)}>} equipment_type), equipment_type). This is either doesn't work or selects only the first item in the list, even though the set analysis shows the whole list. Any ideas on how to get this to work? Many thanks.
We have multiple qlik replicate servers in our environment that a particular group of users have access to. One group has access to one qlik replicate server and the other group has access to the other qlik replicate server. However, when any of the users log in to Enterprise Manager, they are able to see all the servers and their corresponding tasks. They can even make changes to any of the tasks on any of the servers.
How can we restrict these users to only see the server they have access to? I noticed there is an All Servers tab in the permissions window, but if I remove users from there they cannot see anything. Is it really an all or nothing kind of permission model?
Thanks for any help you can provide.
Hello,
Qlikview question: Have a stacked combo chart with Year and Category as dimensions
For 2022,
Fee (Category)= negative (-11,781)
Flow (Category)=Positive (359,661)
But the total on the top shows up as 359,661 and not 347,880 (Attached is a SS).
Any idea why? Thanks
My table is too big for one Qlik Sense dashboard to run in our production environment, therefore it needs to be split into QVD files for every two year period between 2002 and Year(Today()).
To achieve this, I am running a `for each` loop that would feed every other year value in this range into:
- a WHERE clause of the SQL query filtering by datetime (ISO8601).
- the STORE file path.
LET $(vYearList) = 2002:Year(Today();
for Each Year in $(vYearList)
LOAD STATEMENT;
SQL QUERY
WHERE datetime > ($(Year)-2)-01-01 and datetime < $(Year)-12-31
FROM DB;
Store TABLE into [lib://PATH_$(Year)_($(Year)-2).qvd](qvd);
It would take a while to setup the reprex, but any advice on how you would write this script is appreciated, even if it's just for every year.
Hi All,
Please find the code required for this problem statement -
App:
Load * Inline [
Id,Name
1,App Name1
2,App Name2
3,App Name3
4,App Name4
5,App Name5
];
Log:
Load * Inline [
Id,UserId
1,User1
2,User2
3,User3
4,User4
5,User5
1,User6
2,User4
3,User5
4,User2
5,User7
1,User8
2,User9
3,User4
4,User5
5,User2
];
Employee:
Load * Inline [
UserId,Desk,Role
User1,Desk1,Role1
User2,Desk2,Role2
User3,Desk3,Role3
User4,Desk4,Role4
User5,Desk5,Role5
User6,Desk3,Role6
User7,Desk4,Role7
User8,Desk8,Role3
User9,Desk2,Role4
User10,Desk10,Role10
User11,Desk3,Role11
User12,Desk4,Role12
User13,Desk13,Role13
User14,Desk14,Role3
User15,Desk15,Role4
];
Take a pivot table and use Role and Desk and dimension while Name as a filter selection. Metric should be -
1. Count(distinct {<Id ={"1","2","3","4","5"}>}UserId) - this will provide the list who accessed the app
2. Count(distinct{<Name=>} UserId) - this will give all the users available
3. If(Count(distinct {<Id ={"1","2","3","4","5"}>}UserId) =0,1) - this condition will be used to find all the desk under which none of the users had accessed the app when we select Name as a filter
when am trying aggregation on #3 above its not providing the actual count
Any help here is much appreciated.
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.
10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!
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!
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!