Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 188,722 members
  • 6,038 online
  • 1,742,925 posts
  • 133,640 Solutions
Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW

Welcome to Qlik Community

FOR NEW MEMBERS

Everything you need to make your Qlik Community experience valuable.

SEARCH KNOWLEDGE BASE

Explore official Support and member created content.

QLIKWORLD 2023!

Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.

Analytics

Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

About Qlik Community

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • forum

    New to Qlik Sense

    Full screen icon not visible on charts

    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 noth... Show More

    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.

    Show Less
  • forum

    Qlik Replicate

    Does Replicate support Oracle Exadata as a source

    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 Replic... Show More

    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

    Show Less
  • forum

    New to Qlik Sense

    Money Formatting in QlikSense

    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... Show More

    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!

    Show Less
  • forum

    QlikView Administration

    UTF8

    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... Show More

    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?

    Show Less
  • forum

    New to Qlik Sense

    Converting Minutes UTC to different TimeZones

    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 nee... Show More

    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.

     

    2023-03-31_9-08-21.jpg

     

     

    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')

     

    Show Less
  • forum

    App Development

    Pass variable list from input box to field via button

    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... Show More

    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.

    Show Less
  • forum

    Qlik Enterprise Manager

    Server permission question

    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 replicat... Show More

    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.  

    Show Less
  • forum

    App Development

    Combo Chart showing wrong total for a bar with negative values

    Hello, Qlikview question: Have a stacked combo chart with Year and Category as dimensions For 2022, Fee (Category)= negative (-11,781) Flow (Category)... Show More

    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

    Show Less
  • forum

    QlikView App Dev

    List values from a year range in for loop

    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 yea... Show More

    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.

    Show Less
  • forum

    App Development

    Facing issue in finding in distinct count of a dimension based on metric conditi...

    Hi All, Please find the code required for this problem statement -  App:Load * Inline [Id,Name1,App Name12,App Name23,App Name34,App Name45,App Name5]... Show More

    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.

     

    Show Less

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!

Blogs

Qlik Academic Program Blog

Read the latest blog around the Qlik Academic Program.

Blogs

Qlik Product Innovation Blog

If you want to know what's new across all of the products in our growing Qlik product portfolio.

Blogs

Support Updates Blog

Get the latest Support information about end-of-product support, new service releases, and general support topics.

Blogs

Qlik Design Blog

Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Events and Webinars

QlikWorld 2023, Technical Workshops!

10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!

Choose your workshops

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming